How do I format the "TODAY" field in a query?

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:

  1. In the Query Design, select the "Today" field.

  2. Click on the Style tab in the third column. 

  3. 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.

mMonth as a number with no leading zeros
mmMonth as a number with leading zeros
mmmThree letter abbreviation of the month (e.g. Dec)
mmmmFull name of the month (e.g. December)
dDay as a number with no leading zeros
ddDay as a number with leading zeros
dddThree letter abbreviation of the day of the week (e.g. Wed)
ddddFull name of the day of the week (e.g. Wednesday)
yyTwo digit year
yyyyFour digit year