Placeholders for dates and times

The values are always displayed according to the local area profile.

Placeholder Description Example
[Date.datetime] full date including time 10/21/2011 15:47:23
[Date.dates] full date 21/10/2011
[] day as number, 2 digits 21
[Date.day_short] day as number, 1 or 2 digits 21
[Date.weekday] full name of weekday  Friday
[Date.weekday_short] abbreviated name of weekday Fri
[Date.day_of_year] day of year as number, 1 or 2 digits 293
[Date.week] calendar week as number (1–53)  42
[Date.month] month as number, two digits  10
[Date.month_short] month as number, 1 or 2 digits 10
[Date.month_name] full name of month  October
[Date.month_name_short] abbreviated name of month  Oct
[Date.month_days] number of days in current month 31
[Date.year] year as number, 4 digits 2011
[Date.year_short] year as number, 2 digits  11
[Date.quarter] quarter as number (1 - 4) 2
[Date.half_year] half year as number (1 or 2) 1
[Date.times] full time of day 15:47:23
[Date.hour] hour(00-23) 15
[Date.minute] minute(00-59) 47
[Date.second] seconds(00-59) 23

Date calculations

The placeholders for date and time are intelligent placeholders. This means that calculations can also be performed.

Periods (days, weeks, months, and years) can be either added (+) or subtracted
(-). The starting date is always the present day.

Unit Description Example Result
D day [Date.weekday+30D][Date.dates+30D] Sunday, 11/20/2011
W week calendar week [Date.week-6W] calendar week 36
M month [Date.month_name+3M] [Date.year+3M] January 2012
Y year [Date.dates-10Y] 10/21/2001 

Several mathematical operations can be combined in a placeholder.
For example: the code [Date.dates+2Y-1D] turns to 10/20/2013.

Have more questions? Submit a request


Article is closed for comments.