I've seen some answers on hear about using the Today function to get yesterday, but is there anyway to get Tomorrow?
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)
if you're looking for tomorrow:
if( (([Project.Revised Date]=Today()+1) AND Project.Flag = 0), 1)
hope this helps
Retrieving data ...