Discussion Board for collaboration related to QlikView App Development.
I've seen some answers on hear about using the Today function to get yesterday, but is there anyway to get Tomorrow?
if you're looking for tomorrow:
if( (([Project.Revised Date]=Today()+1) AND Project.Flag = 0), 1)
hope this helps
View solution in original post
Dates are numeric with whole numbers reflecting individual days. Just add 1 and format as a date !
Thanks Jonathan! I attempted this, but with a slightly different syntax. I'll give it a shot and report back.
Cool . let me know if you are attempting to use in SET ANALYSIS or an area where the overall syntax can involve a few more twists.
Think it might need some tweaks, here is the script:
if( (([Project.Revised Date]-today()=-0) AND Project.Flag=0), 1)