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?