Follow

Dates

Overview

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

Subscriber 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
Was this article helpful?
0 out of 1 found this helpful
Have more questions? Submit a request

Comments

Powered by Zendesk