Dates

Date tags include built-in tags to display the system date/time, as well as tags to display a custom Date field and its parts.

Builtin Date Tags

The builtin date tags allow you to display the exact Date and Time that your email message is sent, either as the full date or as date parts, such as Month or Hour. Builtin date tags can also be used with Evaluation tags to provide date calculations in your messages.

Each builtin date tag is displayed below with example results.

Tag	Possible Values	Output	Example Results
`%%$builtin.today%%`	mm/dd/yyyy	Date Only	1/2/2015
`%%$builtin.date%%`	mm/dd/yyyy hh:mm	Date and Time	01/02/2015 2:47PM
`%%$builtin.sqldatetime%%`	yyyy-MM-dd HH:mm:ss	Date in Standard SQL Format	2015-01-02 14:47:57
`%%$builtin.year%%`	yyyy	Year	2015
`%%$builtin.month%%`	1 to 12	Month	1
`%%$builtin.month_padded%%`	01 to 12	Month Padded	01
`%%$builtin.monthname%%`	January - December	Month Name	January
`%%$builtin.monthname_uc%%`	JANUARY - DECEMBER	Month Name Upper Case	JANUARY
`%%$builtin.monthname_lc%%`	january - december	Month Name Lower Case	january
`%%$builtin.monthname_short%%`	Jan - Dec	Month Name Short	Jan
`%%$builtin.monthname_short_uc%%`	JAN - DEC	Month Name Short Upper Case	JAN
`%%$builtin.monthname_short_lc%%`	jan - dec	Month Name Short Lower Case	jan
`%%$builtin.day%%`	1 to 31	Day	2
`%%$builtin.day_padded%%`	01 to 31	Day Padded	02
`%%$builtin.weekday%%`	Sunday - Saturday	Weekday	Friday
`%%$builtin.weekday_uc%%`	SUNDAY - SATURDAY	Weekday Upper Case	FRIDAY
`%%$builtin.weekday_lc%%`	sunday - saturday	Weekday Lower Case	friday
`%%$builtin.weekday_short%%`	Sun - Sat	Weekday Short	Fri
`%%$builtin.weekday_short_uc%%`	SUN - SAT	Weekday Short Upper Case	FRI
`%%$builtin.weekday_short_lc%%`	sun - sat	Weekday Short Lower Case	fri
`%%$builtin.juliandate%%`		Julian Date	2457024
`%%$builtin.timezone%%`		Time Zone	PST
`%%$builtin.hour%%`	1 to 12	Hour	2
`%%$builtin.hour_24%%`	1 to 24	Hour 24	14
`%%$builtin.minutes%%`	mm	Minutes	47
`%%$builtin.seconds%%`	ss	Seconds	57
`%%$builtin.AMPM%%`	AM or PM	AM/PM	PM

Date Part Tags

If you need to display or evaluate parts of Dates, you can add a date part parameter to the Tag. The date part parameter works with variable Dates set in the template, Contact Data, and Custom Data. Each date part tag is displayed below with example results, where DATE is the name of the variable or data field.

Contact Data and Custom Data do not support the 'padded' date options. To create a padded version of a custom field, use the EVAL tag with formatdate as follows:

%%set format = "MM/dd/yyyy"%%

%%eval formatdate $format $DATE%%

Tag	Possible Values	Output	Results
`%%$DATE.year%%`	yyyy	Year	2007
`%%$DATE.month%%`	1 to 12	Month	3
`%%$DATE.month_padded%%`	01 to 12	Month Padded	3
`%%$DATE.monthname%%`	January - December	Month Name	March
`%%$DATE.monthnameabbrev%%`	Jan - Dec	Month Name Short	Mar
`%%$DATE.day%%`	1 to 31	Day	9
`%%$DATE.day_padded%%`	01 to 31	Day Padded	9
`%%$DATE.dayofweek%%`	Sunday - Saturday	Weekday	Thursday
`%%$DATE.dayofweekabbrev%%`	Sun - Sat	Weekday Short	Thurs
`%%$DATE.hour%%`	1 to 12	Hour	11:00AM
`%%$DATE.minute%%`	mm	Minutes	0
`%%$DATE.second%%`	ss	Seconds	0