Overview
Several Logic Tags are used to evaluate date values and output results to the content.
Tags
Dates can be literal (defined within brackets [05/11/2011]), builtin (builtin.today - without preceding $), variable (set in the template %%set date1 = 05/10/2011%%), or Contact or Custom Data ($customDate).
| Tag | %%eval age DATE%% |
| Parameters | DATE: Date Literal, Variable, Custom Data, or Contact Data |
| Output | Output the number of years between today's date and the specified date. This is useful for age, anniversary type calculations. |
| Example | %%set dob = "12/31/1975"%% |
| %%eval age $dob%% | |
| Results | 35 |
| Tag | %%eval dateadd DATE INT%% |
| Parameters | DATE: Date Literal, Variable, Custom Data, or Contact Data |
| INT: Integer Literal, Variable, Custom Data, or Contact Data | |
| Output | Output the date adding the integer to the days of the date to result in a new date. |
| Example | %%set date2 = 05/11/2011%% |
| %%eval dateadd $date2 [11]%% | |
| Results | 5/22/2011 |
| Tag | %%eval daysbetween DATE1 DATE2%% |
| Parameters | DATE: Date Literal, Variable, Custom Data, or Contact Data |
| Output | Output the number of days between two dates. |
| Example | %%set date1 = 05/21/2011%% |
| %%eval daysbetween $date1 [05/31/2011]%% | |
| Results | 10 |
| Tag | %%eval formatdate FORMAT builtin.sqldatetime%% |
| Parameters | FORMAT: Set variable with defined format. Specific characters are interpreted as pattern letters representing the components of a date or time string. Text can be quoted using single quotes (') To print a single quote, use "'". See the table below for description of each character purpose. |
| Output | Output the result of applying a specified format to the current date. |
| Example | %%set formatDate = "E, dd MMM yyyy HH:mm:ss Z"%% |
| %%eval formatdate $formatDate builtin.sqldatetime%% | |
| Results | Fri, 22 Jul 2011 10:56:26 -0700 |
| Example | %%set formatDate = "MM/dd/yyyy hh:mm:ss zzz"%% |
| %%eval formatdate $formatDate builtin.sqldatetime%% | |
| Results | 07/22/2011 10:56:26 PDT |
| Example | %%set formatDate = "EEEE, MMMM 'the' dd 'of' yyyy 'at' hh:mm a"%% |
| %%eval formatdate $formatDate builtin.sqldatetime%% | |
| Results | Friday, July the 22 of 2011 at 10:56 AM |
| Example | %%set formatDate = "MM/dd/yyyy"%% |
|
%%set newdate = {{eval dateadd builtin.today [10]}}%% %%eval formatdate $formatDate $newdate%% |
|
| Results | 08/01/2011 |
| Letter | Component | Type | Example |
| G | Era designator | Text | G = AD |
| y | Year | Year | yyyy = 2011; yy = 11 |
| Y | Week year | Year | YYYY = 2011; YY = 11 |
| M | Month in year | Month | MMMM = July; MMM = Jul; MM = 07; M = 7 |
| w | Week in year | Number | w = 30 |
| W | Week in month | Number | W = 4 |
| D | Day in year | Number | D = 203 |
| d | Day in month | Number | dd = 07; d = 7 |
| F | Day of week in month | Number | FF = 04; F = 4 |
| E | Day name in week | Text | EEEE = Friday; E = Fri |
| u | Day number of week (1 = Monday, ..., 7 = Sunday) | Number | u = 1 |
| a | Am/pm marker | Text | a = PM |
| H | Hour in day (0-23) | Number | H = 0; HH = 00 |
| k | Hour in day (1-24) | Number | k = 1; kk = 01 |
| K | Hour in am/pm (0-11) | Number | K = 0; KK = 00 |
| h | Hour in am/pm (1-12) | Number | h = 1; hh = 01 |
| m | Minute in hour | Number | m = 0; mm = 00 |
| s | Second in minute | Number | s = 0; ss = 00 |
| S | Millisecond | Number | S = 0; SSS = 000 |
| z | Time zone | General time zone | zzzz = Pacific Daylight Time; z = PDT |
| Z | Time zone | RFC 822 time zone | Z = -0700; ZZ = -07 |
| X | Time zone | ISO 8601 time zone | X = -07; XX = -0700; XXX = -07:00 |