No Translation available yet
You have Slovak selected as language but this page has not been translated yet. Translate the page or view the content in the default space language below.
Display default
Datetime Constants
Accessing context datetime
Function | Description |
---|
String contextDay()
| Returns the formula's context day dd.MM.yyyy format (or domain format). |
String contextWeek()
| Returns the beginning of the context's week in dd.MM.yyyy format (or domain format). |
String contextMonth()
| Returns the beginning of the context's month in dd.MM.yyyy format (or domain format). |
String contextQuarter()
| Returns the beginning of the context's year in dd.MM.yyyy format (or domain format). |
String contextYear()
| Returns the formula's context week start in dd.MM.yyyy format (or domain format). |
int dateDayOfYear()
| Returns the day of year from the context date |
int dateDayOfMonth()
| Returns the day of month from the context date |
int dateDayOfWeek()
| Returns the day of week from the context date |
int dateMonth()
| Returns the number of month from the context date |
int dateYear()
| Returns the number of month from the context date |
int timeHour()
| Returns the number of hour from the context time |
int timeMinute()
| Returns the number of minute from the context time |
int timeSecond()
| Returns the number of second from the context time |
int daysInMonth()
| 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 |
String contextDay() | 31.1.2011 | 1.2.2011 | 2.2.2011 |
String contextWeek() | 31.1.2011 | 31.1.2011 | 31.1.2011 |
String contextMonth() | 1.1.2011 | 1.2.2011 | 1.2.2011 |
String contextQuarter() | 1.1.2011 | 1.1.2011 | 1.1.2011 |
String contextYear() | 1.1.2011 | 1.1.2011 | 1.1.2011 |
int dateDayOfYear() | 31 | 32 | 33 |
int dateDayOfMonth() | 31 | 1 | 2 |
int dateDayOfWeek() | 1 | 2 | 3 |
int dateMonth() | 1 | 2 | 2 |
int dateYear() | 2011 | 2011 | 2011 |
int timeHour() | 0 | 0 | 0 |
int timeMinute() | 1 | 1 | 1 |
int timeSecond() | 0 | 0 | 0 |
Accessing actual date and time
Function | Description |
---|
String actualDay()
| Returns the actual day in dd.MM.yyyy format |
String actualDate() | Returns the actual day in dd.MM.yyyy format |
String actualWeek()
| Returns the actual week in dd.MM.yyyy format |
String actualMonth()
| Returns the actual month in dd.MM.yyyy format |
String actualQuarter()
| Returns the actual quarter in dd.MM.yyyy format |
String actualYear()
| Returns the actual year in dd.MM.yyyy format |
String actualTime() | Returns the current time in HH:mm:ss format |
String actualDateTime() | Returns the actual date and time in yyyy-MM-dd HH:mm:ss |
Accessing date interval values
Function | Description |
---|
String viewDateFrom()
| Returns the day used as Date from in date interval settings in yyyy-MM-dd format |
String viewDateTo() | Returns the day used as Date to in date interval settings in yyyy-MM-dd format |
String viewTimeFrom()
| Returns the time used as Time from in time interval settings in HH:mm:ss.SSS format |
String viewTimeTo()
| Returns the time used as Time to in time interval settings in HH:mm:ss.SSS format |
Next Steps