Datetime Constants

String contextDay()

Returns the formula's context day in dd.MM.yyyy format.

String contextWeek()

Returns the beginning of the context's week in dd.MM.yyyy format. Example:

String contextMonth()

Returns the beginning of the context's month in dd.MM.yyyy format.

String contextQuarter()

Returns the beginning of the context's year in dd.MM.yyyy format.

String contextYear()

Returns the formula's context week start in dd.MM.yyyy 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

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

String actualDay()

Returns the actual day in dd.MM.yyyy format

String actualDate()

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