Datetime Constants
Accessing context datetime
Function | Description |
---|---|
| Returns the formula's context day in |
| Returns the beginning of the context's week in |
| Returns the beginning of the context's month in |
| Returns the beginning of the context's year in |
| Returns the formula's context week start in |
| Returns the day of year from the context date |
| Returns the day of month from the context date |
| Returns the day of week from the context date |
| Returns the number of month from the context date |
| Returns the number of month from the context date |
| Returns the number of hour from the context time |
| Returns the number of minute from the context time |
| Returns the number of second from the context time |
| Returns the number of days in the context date |
Examples:
| 31.1.2011 00:01:00 | 1.2.2011 00:01:00 | 2.2.2011 00:01:00 |
contextDay() | 31.1.2011 | 1.2.2011 | 2.2.2011 |
contextWeek() | 31.1.2011 | 31.1.2011 | 31.1.2011 |
contextMonth() | 1.1.2011 | 1.2.2011 | 1.2.2011 |
contextQuarter() | 1.1.2011 | 1.1.2011 | 1.1.2011 |
contextYear() | 1.1.2011 | 1.1.2011 | 1.1.2011 |
dateDayOfYear() | 31 | 32 | 33 |
dateDayOfMonth() | 31 | 1 | 2 |
dateDayOfWeek() | 1 | 2 | 3 |
dateMonth() | 1 | 2 | 2 |
dateYear() | 2011 | 2011 | 2011 |
timeHour() | 0 | 0 | 0 |
timeMinute() | 1 | 1 | 1 |
timeSecond() | 0 | 0 | 0 |
Accessing actual date
Function | Description |
---|---|
| Returns the actual day in |
String actualDate() | Returns the actual day in dd.MM.yyyy format |
| Returns the actual week in |
| Returns the actual month in |
| Returns the actual quarter in |
| Returns the actual year in |