Template Design Studio - Date Formatting Options
RecTrac 3.1
Table of Contents
Template Design Studio offers a wide variety of ways to format the display of Dates on your templates. The following presents a basic example for adding a Date Format field. The table below provides the list of formatting options.
To Add a Date Format Field to a Template
The following example describes how you might add a Member Since Date field to a Pass Template. When adding a Date Field to a Template, the basic steps outlined here remain the same regardless of the Template Record Type with which you are working.
- On the Template Maintenance Details for <Your Template> screen, Add a Text field. You will continue to the Template Maintenance Object Update screen.
- Enter a name for your text field in the Object Label field.
- In the Text field, add miscellaneous text as needed. For purposes of this example, "Member Since: "
- Expand the Drop-down list for Function Presets and select "Format Date (Blank for current Date - formatdate(Value,Format,Weekday Option)"
You make this selection because you want to add a Date field. - Expand the Drop-down list for Table/Field Presets and select "SADETAIL_OriginalMemberDate"
You make this selection because you want to display the "Member Since" Date, which is the Original Member Date of the membership.
Click Image to Enlarge
Notes:
- When adding Dates to Templates, you need to know the field and/or table that corresponds to the Date you want to display. Your selection in this field, therefore, is dependent upon the type of Template with which you're working. If adding an event date to a POS Ticket, for example, your selection would be PSTicketMain_BeginEventDate.
- To display a Date that is not linked to a field or table, use the Function Presets only and skip the Table/Field Presets field. For Example: If you want to display a static date only, such as July 4, 2020, then you would add the "Format Date" field and you would skip the "Table/Field Presets" field.
- Click Add Preset. Your entries will be placed in the Text field.
Click Image to Enlarge
- The <DATEFORMAT> field determines how the Date will display.
- Remove the < > brackets. Regardless of the date format you use, the brackets must be deleted.
- Use "DATEFORMAT" to have the date display in your RecTrac default date format, as determined on your Static Parameters profile • Formatting Options group.
- To use a static date, enter it in front of "DATEFORMAT." For Example: Enter "07/04/2020,DATEFORMAT" to have the July 4 static date appear on your template in your RecTrac default date format.
- To use a date display format other than your RecTrac default, overwrite "DATEFORMAT" with the format you wish to use. The table below provides the list of formatting options. For Example: Overwrite "DATEFORMAT" with "January 01 yyyy" to have the date display as July 04, 2020..
Click Image to Enlarge
- The <DAYOFWEEKOPTION> field determines how the Day of the Week will display.
- Remove the < > brackets. Regardless of the day format you use, the brackets must be deleted.
- Use "NONE" to skip the day of the week display.
- Use "SHORT" to have the day of the week display in three-letter format. For Example: Sat.
- Use "LONG" to have the day of the week display in full format. For Example: Saturday.
- Click Done when finished. You will return to the Template Maintenance Details for <Your Template> screen. Use the Preview or Quick Preview option to test your results.
Valid Date Formats
The following table provides the list of formatting options for dates in Template Design Studio using July 4, 2020 as the example with the lone exception to that example being "today." In all instances, the DAYOFWEEKOPTION is either "Short" or "None." Valid DAYOFWEEKOPTIONs are:
- NONE - Skips the day of the week display.
- SHORT - Displays the day of the week in three-letter format. For Example: Sat.
- LONG - Displays the day of the week display in full format. For Example: Saturday.
Valid Date Format | <?formatdate(<VALUE>,<DATEFORMAT>,<DAYOFWEEKOPTION>)?> | Template Display |
---|---|---|
today | <?formatdate(today,<date format>,<weekday format>)?> | Prints "today's date" in your selected Date/Weekday Format |
DATEFORMAT | <?formatdate(07/04/2020,DATEFORMAT,NONE)?> | Prints the date in your RecTrac default date format. |
Jan 01 yyyy - Note: Enter as displayed. Do not insert commas. | <?formatdate(07/04/2020,Jan 01 yyyy,SHORT)?> | Sat, Jul 04, 2020 |
Jan 1 yyyy | <?formatdate(07/04/2020,Jan 1 yyyy,SHORT)?> | Sat, Jul 4, 2020 |
Jan 01 yy | <?formatdate(07/04/2020,Jan 01 yy,SHORT)?> | Sat, Jul 04, 20 |
Jan 1 yyyy | <?formatdate(07/04/2020,Jan 1 yy,SHORT)?> | Sat, Jul 4, 20 |
Jan 1st yyyy | <?formatdate(07/04/2020,Jan 1st yyyy,SHORT)?> | Sat, Jul 4th, 2020 |
Jan 1st yy | <?formatdate(07/04/2020,Jan 1st yy,SHORT)?> | Sat, Jul 4th, 20 |
January 01 yyyy | <?formatdate(07/04/2020,January 01 yyyy,SHORT)?> | Sat, July 04, 2020 |
January 1 yyyy | <?formatdate(07/04/2020,January 1 yyyy,SHORT)?> | Sat, July 4, 2020 |
January 01 yy | <?formatdate(07/04/2020,January 01 yy,SHORT)?> | Sat, July 04, 20 |
January 1 yy | <?formatdate(07/04/2020,January 1 yy,SHORT)?> | Sat, July 4, 20 |
January 1st yyyy | <?formatdate(07/04/2020,January 1st yyyy,SHORT)?> | Sat, July 4th, 2020 |
January 1st yy | <?formatdate(07/04/2020,January 1st yy,SHORT)?> | Sat, July 4th, 20 |
01 Jan yyyy | <?formatdate(07/04/2020,01 Jan yyyy,SHORT)?> | Sat, 04 Jul 2020 |
01 Jan yy | <?formatdate(07/04/2020,01 Jan yy,SHORT)?> | Sat, 04 Jul 20 |
01 January yyyy | <?formatdate(07/04/2020,01 January yyyy,SHORT)?> | Sat, 04 July 2020 |
01 January yy | <?formatdate(07/04/2020,01 January yy,SHORT)?> | Sat, 04 July 20 |
1 Jan yyyy | <?formatdate(07/04/2020,1 Jan yyyy,SHORT)?> | Sat, 4 Jul 2020 |
1 Jan yy | <?formatdate(07/04/2020, 1 Jan yy,SHORT)?> | Sat, 4 Jul 20 |
1 January yyyy | <?formatdate(07/04/2020,1 January yyyy,SHORT)?> | Sat, 4 July 2020 |
1 January yy | <?formatdate(07/04/2020, 1 January yy,SHORT)?> | Sat, 4 July 20 |
Jan 1 | <?formatdate(07/04/2020, Jan 1,SHORT)?> | Sat, Jul 4 |
Jan 01 | <?formatdate(07/04/2020, Jan 01,SHORT)?> | Sat, Jul 04 |
Jan 1st | <?formatdate(07/04/2020, Jan 1st,SHORT)?> | Sat, Jul 4th |
1 Jan | <?formatdate(07/04/2020,1 Jan,SHORT)?> | Sat, 4 Jul |
01 Jan | <?formatdate(07/04/2020,01 Jan,SHORT)?> | Sat, 04 Jul |
1 January | <?formatdate(07/04/2020,1 January,SHORT)?> | Sat, 4 July |
01 January | <?formatdate(07/04/2020,01 January,SHORT)?> | Sat, 04 July |
January 1 | <?formatdate(07/04/2020,January 1,SHORT)?> | Sat, July 4 |
January 01 | <?formatdate(07/04/2020,January 01,SHORT)?> | Sat, July 04 |
January 1st | <?formatdate(07/04/2020,January 1st,SHORT)?> | Sat, July 4th |
Jan yyyy | <?formatdate(07/04/2020,Jan yyyy,NONE)?> | Jul 2020 |
Jan yy | <?formatdate(07/04/2020,Jan yy,NONE)?> | Jul 20 |
January yyyy | <?formatdate(07/04/2020,January yyyy,NONE)?> | July 2020 |
January yy | <?formatdate(07/04/2020,January yy,NONE)?> | July 20 |
mm/dd/yyyy | <?formatdate(07/04/2020, mm/dd/yyyy,SHORT)?> | Sat, 7/4/2020 |
mm/dd/yy | <?formatdate(07/04/2020, mm/dd/yy,SHORT)?> | Sat, 7/4/20 |
dd/mm/yyyy | <?formatdate(07/04/2020, dd/mm/yyyy,SHORT)?> | Sat, 4/7/2020 |
dd/mm/yy | <?formatdate(07/04/2020, dd/mm/yy,SHORT)?> | Sat, 4/7/20 |
mm/yyyy | <?formatdate(07/04/2020, mm/yyyy,NONE)?> | 7/2020 |
mm/yy | <?formatdate(07/04/2020, mm/yy,NONE)?> | 7/20 |
mm/dd | <?formatdate(07/04/2020, mm/dd,SHORT)?> | Sat, 7/4 |