Description: When creating Admin Defined Table templates users may need to perform conditional operations based on date/time values, but IF functions are not available for comparing date/time values.
Cause: Currently, IF statements in Signals Notebook cannot directly work with Date/Time fields. When attempting to create an equation using an IF statement to compare date values (such as determining if one date is before another), the date/time columns will not appear as available options in the equation builder.
Solution: To perform conditional operations based on date comparisons use the DATEDIFF() equation by following these steps:
1. Add an extra column to your table with a Number data type
2. In this column, use the DATEDIFF() function to calculate the difference between your two date fields
3. Use the resulting numerical value in your IF statement