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 |
[Date.day] |
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.
0 Comments