End of Week & End of month

[joeybird]

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

[jpenuliar]

Do you want to flag if your [OrderCompleteTargetDate] falls on a Sunday ?

you can probably do if([OrderCompleteTargetDate] = WeekEnd(Today()),1,0)

[jpenuliar · Accepted solution]

You can also look into MonthEnd() function

[joeybird]

Hiya

worked a treat

thank you

kind regards

joeybird