Date Functions

These functions are available for Calculated Fields and Crosstabs.

Function ToDate( <Expression> , <Expression> , <Expression> )
Description Returns a date value.
Arguments

Each expression can either contain a date field or a numeric value. The 1st expression contains the year element. The 2nd expression contains the month element. The 3rd expression contains the minute element.
Examples

Raised_Date = 15/01/2015 Closed_Date = 16/01/2015

  • ToDate( 2014, 11, 8 ) would return 08/11/2014
  • ToDate ( ToYear(Raised_Date), ToMonth(Raised_Date), ToDay(Raised_Date) ) would return 15/01/2015
  • ToDate ( ToYear(Raised_Date), 12, 1 ) would return 01/12/2015
  • ToDate ( ToYear(Raised_Date), 12, ToDay(Closed_Date) ) would return 16/12/2015

Note: The output value will be a date field when created as a Calculated Field for an Index. For a Crosstab, the output value will actually be a numeric representation of the date. However, the value can still be used for calculations that require date comparisons/logic.

Function ToDateTime( <Expression> , <Expression> , <Expression> , <Expression> , <Expression> , <Expression> )
Description Returns a datetime value.
Arguments

Each expression can either contain a date field or a numeric value.

The 1st expression contains the year element. The 2nd expression contains the month element. The 3rd expression contains the day element. The 4th expression contains the hour element. The 5th expression contains the minute element. The 6th expression contains the seconds element.
Examples

Raised_Date = 15/01/2015 14:08:11 Closed_Date = 16/01/2015 09:21:45

  • ToDateTime ( 2014, 11, 8, 19, 02, 45 ) would return 08/11/2014 19:02:45
  • ToDateTime (ToYear(Raised_Date), ToMonth(Raised_Date), ToDay(Raised_Date), ToHour(Raised_Date), ToMinute(Raised_Date), ToSecond(Raised_Date ) ) would return 15/01/2015 14:08:11
  • ToDateTime ( ToYear(Raised_Date), 12, 1, ToHour(Raised_Date), 1, 59 ) would return 01/12/2015 14:01:59
  • ToDateTime ( ToYear(Raised_Date), 12, ToDay(Closed_Date), 1, 59, ToSecond(Closed_Date) ) would return 16/12/2015 01:59:45

Note: The output value will be a date field when created as a Calculated Field for an Index. For a Crosstab, the output value will actually be a numeric representation of the date. However, the value can still be used for calculations that require date comparisons/logic.

Function NOW
Description Returns current system date and time
Arguments  
Examples
  • NOW-1DAY would return a date and time value for the previous day.