Condition and date

[CentTrois]

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 ?

[amitchandak · Accepted solution]

@CentTrois , Try like

= if [createdon] > Date.AddDays(Date.From(DateTime.LocalNow()),-90)  then "en retard" else "a jour"

[CentTrois]

@amitchandak  Hi

Unfortunaly, the behavior is the same. The sign > produces an error.

[CentTrois]

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

[CentTrois]

It works by changing the date format, thanks for your help and my apologies, I should have read that **bleep** error message.