As of July 12, 2021, this "Learn Veracross" site has been deprecated. It will remain live at least through December 23, 2021, but will no longer be updated. Q&A articles are only visible to authenticated users in the Veracross Community; please speak with your implementation or account manager for additional information.
The date field defaults to the MM/DD/YYYY format in a query but can be adjusted based on user preference.
Note: this field is currently only available in the Donation and Pledge queries.
To do this:
In the Query Design, select the "Today" field.
Click on the Style tab in the third column.
Use the Override Display Format field to set the format as desired.
Use a combination of the formats below separated by "/" or "," to set the date format in the query.
| Format | Description |
| m | Month as a number with no leading zeros |
| mm | Month as a number with leading zeros |
| mmm | Three letter abbreviation of the month (e.g. Dec) |
| mmmm | Full name of the month (e.g. December) |
| d | Day as a number with no leading zeros |
| dd | Day as a number with leading zeros |
| ddd | Three letter abbreviation of the day of the week (e.g. Wed) |
| dddd | Full name of the day of the week (e.g. Wednesday) |
| yy | Two digit year |
| yyyy | Four digit year |