Forum Discussion
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 DateTime.LocalNow = (Date.AddDays([createdon],90)) then "en retard" else "a jour"
But it no longer works with the argument: >
= if DateTime.LocalNow > (Date.AddDays([createdon],90)) then "en retard" else "a jour"
can you help me please ?
CentTrois , Try like
= if [createdon] > Date.AddDays(Date.From(DateTime.LocalNow()),-90) then "en retard" else "a jour"
4 Replies
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 column
