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.
Parent topic: Rules helper function reference