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

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.

FormatDescription
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