what do you have in else option? did you leave it empty?
yes, i make if the end date before today then choose end date
if the end date after today then choose today.
else empty.
thatās why is formating as text, put a date there meybe start date
you are missing r in start
what r ?
why is showing an invalid operation?
Thatās my main questionā¦
now date is a date? from the math column
yes, correct. when it comes to if then column it cannot detect as date
you doing something wrongā¦ it works for meā¦
is probably the way you calculate āNow Dateā in the math column, you have empty rows or some other than date format there, thatās why it canāt format to date
is the results right ?
yes, all my apps work on durations
this is my now date
both didnt work with +0 or without
you have something on the way that is not formated as DATE, sometimes is hard to find, maybe is coming from relations, or you manually enter or edit some of the dates?
If is not too much work, I will redo all these columns
refresh the editor and try to make a fresh sample, with a new columns formatted as a date, fill them up with a date pickerā¦ and if is still not working, then submit a ticket to glideā¦