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 |
|
Returns the actual week in |
|
Returns the actual month in |
|
Returns the actual quarter in |
|
Returns the actual year in |