View the original community article here
Last tested: June 2020
There are two methods for date comparison in table calcs.
-
Use
diff_days
or any of the otherdiff_
functions (docs).
For example, to say "${date_a} > $[date_b}", just dodiff_days(${date_b},${date_a}) > 0
. -
The
extract_
familiy of functions can be useful since they let you extract a numeric value (year, month, day, etc) from a date or timestamp. Docs on that.
If you need something simple like "date is after January 1, 2017", then just doextract_years(${date}) > 2017
.
This content is subject to limited support.