Compare date with now

Ask for Help Formulas
1

I want to compare a date field with the actual date for a conditional formating.
As spreadsheet user I would use something like =IF(NAME_OF_DATEFIELD < TODAY();“true”;“false”) but in GRIST some things are much more complicated. I have solved it with

if $WV:
  return $WV <= $NOW

and $NOW contains =NOW() (formatted as DATE)

But it is very annoying to use a column only for receiving the actual date, but…

if $WV:
  return $WV <= NOW()

says: “TypeError : can’t compare datetime.datetime to datetime.date’”

OK, but how can I change datetime.datetime to datetime.date to correct this formula?

2

TODAY()

Or make WV a DateTime column.

1 Like