Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community,
I've seen some answers on hear about using the Today function to get yesterday, but is there anyway to get Tomorrow?
Regards,
M
if you're looking for tomorrow:
if( (([Project.Revised Date]=Today()+1) AND Project.Flag = 0), 1)
hope this helps
regards
Marco
Dates are numeric with whole numbers reflecting individual days. Just add 1 and format as a date !
=date(today()+1)
Thanks Jonathan! I attempted this, but with a slightly different syntax. I'll give it a shot and report back.
Regards,
My
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
regards
Marco
Worked beautifully!
you're welcome
regards
Marco