This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 . It is not the current version, and thus it cannot be edited.
[Back to current version]   [Restore this version]

Date Variables
#

Date variables can be used to reference the current file item's date/time. Ubiquitous, an be used in any context (user events, alerts, various email templates,jobs).
{MM} month number
{MMM} month abbreviated
{MMMM} month full
{dd} day
{yy} or {yyyy} year
{HH} 24 hour
{mm} minute
{hh} 12 hour
{aa} AM or PM
{ss} seconds
{S} milliseconds
{EEE} weekday abbreviated
{EEEE} weekday full
{W} week number in the current month
{w} week number in the current year
{u} day number of the week
{D}or {DD} day number in the current year
{F} day of week in month
{z} general timezone
{Z} RFC 822 time zone
{J} julian date
{millis} millisecond time

{yesterday} millisecond time of yesterday (no variations)
{time} or {now} millisecond time of now (no variations)

Variations#

A leading '.' indicates now. {.MM}{.dd}{.yyyy}
A leading '!' indicates yesterday. {!MM}{!dd}{!yyyy}
A leading '!!' indicates last week. {!!MM}{!!dd}{!!yyyy}
A leading '!!!' indicates last month. {!!!MM}{!!!dd}{!!!yyyy}
A trailing '_' indicates the file start transfer time (for events). {MM_}{dd_}{yyyy_} {HH_}{mm_}{ss_}{S_}
A leading '_' indicates the file end transfer time (for events). {_MM}{_dd}{_yyyy} {_HH}{_mm}{_ss}{_S}

To add days or remove days from the time, you can use {dateadd:X}. Example to add 5 days:{dateadd:5}{.MM}{.dd}{.yyyy}

---

User Event related
#

Can be used in user Events and some, in Alerts.