Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

End of Week & End of month

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

1 Solution

Accepted Solutions
jpenuliar
Partner - Specialist III
Partner - Specialist III

You can also look into MonthEnd() function

View solution in original post

3 Replies
jpenuliar
Partner - Specialist III
Partner - Specialist III

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

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

jpenuliar
Partner - Specialist III
Partner - Specialist III

You can also look into MonthEnd() function

joeybird
Creator III
Creator III
Author

Hiya

worked a treat

thank you

kind regards

joeybird