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