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

    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

    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