Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hiya
using ....
let vstart='20050101';
let vend=date(Today(), 'YYYYMMDD');
i wish to call a stat for End of week and End of Month
this below gives me 7 days
if(([OrderCompleteTargetDate]-'$(vend)') <= (7*24), 1,0) as [7 Day Warning],
how would I amend above to give me [end of week warning] ('Sunday') and [end of 'current' month warning] (current month from today will be end of May 2015)
Please help
Kind Regards
joeybird
You can also look into MonthEnd() function
Do you want to flag if your [OrderCompleteTargetDate] falls on a Sunday ?
you can probably do if([OrderCompleteTargetDate] = WeekEnd(Today()),1,0)
You can also look into MonthEnd() function
Hiya
worked a treat
thank you
kind regards
joeybird