Using the Now or Today

[#1]

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

[JonnyPoole]

Dates are numeric with whole numbers reflecting individual days. Just add 1 and format as a date !

=date(today()+1)

[#3]

Thanks Jonathan! I attempted this, but with a slightly different syntax. I'll give it a shot and report back.

Regards,

My

[JonnyPoole]

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.

[#5]

Think it might need some tweaks, here is the script:

if( (([Project.Revised Date]-today()=-0) AND Project.Flag=0), 1)

 

[MarcoWedel · Accepted solution]

if you're looking for tomorrow:

if( (([Project.Revised Date]=Today()+1) AND Project.Flag = 0), 1)

hope this helps

regards

Marco

[#7]

Worked beautifully!

[MarcoWedel]

you're welcome

regards

Marco