if statement in Script

[TomBond77]

Hi experts

I have this statement in the loading script:

if(date(Timestamp, 'YYYY-MMM')= date(Addmonths(MonthEnd(Today()),-1), 'YYYY-MMM'), [Event Reason]) as [Event Reason_new]

It is not working, although the date fields are correct in the app:

Any ideas?

[brunobertels · Accepted solution]

hi 

try 

if(date(floor(Timestamp), 'YYYY-MMM')= date(Addmonths(MonthEnd(Today()),-1), 'YYYY-MMM'), [Event Reason]) as [Event Reason_new]

[TheoAtragie]

Good morning,

This doesn't work because you're comparing a date and a timestamp. (The date function is a formatting function.
Try this :
if(date(dayname(Timestamp), 'YYYY-MMM')= date(Addmonths(MonthEnd(Today()),-1), 'YYYY-MMM'), [Event Reason]) as [Event Reason_new]

Cordialement,
Théo ATRAGIE.

[TomBond77]

solved it:

if(monthend(date(floor(Timestamp), 'YYYY-MMM'))= monthend(date(Addmonths(MonthEnd(Today()),-1), 'YYYY-MMM')), [Event Reason]) as [Event Reason_new] ,