Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
hi
try
if(date(floor(Timestamp), 'YYYY-MMM')= date(Addmonths(MonthEnd(Today()),-1), 'YYYY-MMM'), [Event Reason]) as [Event Reason_new]
hi
try
if(date(floor(Timestamp), 'YYYY-MMM')= date(Addmonths(MonthEnd(Today()),-1), 'YYYY-MMM'), [Event Reason]) as [Event Reason_new]
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.
solved it:
if(monthend(date(floor(Timestamp), 'YYYY-MMM'))= monthend(date(Addmonths(MonthEnd(Today()),-1), 'YYYY-MMM')), [Event Reason]) as [Event Reason_new] ,