Forum Discussion
Solved
Condition and date
Hello everyone, Forgive my automatically translated post. I'm having trouble with a date condition. I want to differentiate between entries older than 90 days. My following query works: = if Da...
CentTrois , Try like
= if [createdon] > Date.AddDays(Date.From(DateTime.LocalNow()),-90) then "en retard" else "a jour"
CentTrois , Try like
= if [createdon] > Date.AddDays(Date.From(DateTime.LocalNow()),-90) then "en retard" else "a jour"
amitchandak Hi
Unfortunaly, the behavior is the same. The sign > produces an error.
Here is the message error :
Expression.Error : Désolé... Nous n'avons pas pu appliquer l'opérateur > aux types Function et Date.
Détails :
Operator=>
Left=[Function]
Probably the format columnIt works by changing the date format, thanks for your help and my apologies, I should have read that **bleep** error message.