Date and time functions

Compare and manipulate date and time values.

Note:

For date-related functions, partial dates are not supported except where they are explicitly mentioned.

• dateDiffInYears( )
  Calculate the difference between two dates in years. For instance, when you have two questions of type Date in a form.
• dateDiffInDays( )
  Calculate the date difference between two dates measured in days.
• timeDiffInHours( )
  Calculate the time difference between two date or date/time values in hours.
• timeDiffInMinutes( )
  Calculate the time difference between two date or date/time values in minutes.
• timeDiffInSeconds( )
  Calculate the time difference between two date or date/time values in seconds.
• areDatesEqual( )
  Compare two dates to determine if they are equivalent.
• isDateInRange( )
  Verify if a date falls within a defined range.
• areDateTimesEqual( )
  Compare two date or date/time values to determine if they are equivalent.
• isTimeInRange( )
  Verify if a date or date/time value falls within a defined range.
• addDays( )
  Add a specific number of days to a date value. For example, when you need to ensure the Date and Time entered by the user doesn't exceed a specific value.
• addTimeInHours( )
  Add a specific number of hours to a date or date/time value. For example, when you need to ensure the Date and Time entered by the user doesn't exceed a specific value.
• addTimeInMinutes( )
  Add a specific number of minutes to a date or date/time value. For example, when you need to ensure the Date and Time entered by the user doesn't exceed a specific value.
• getDateDMYFormat( )
  Return a date or datetime in DD-Mon-YYYY format, including time elements if applicable. This function supports partial dates.
• getDatesCompareResult( )
  Compare two dates using a provided operation. This function handles partial dates.
• partialDateDiff( )
  Find the difference between two dates.