Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Using the Now or Today

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

1 Solution

Accepted Solutions
MarcoWedel

if you're looking for tomorrow:

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


hope this helps


regards


Marco

View solution in original post

7 Replies
JonnyPoole
Employee
Employee

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

=date(today()+1)

Not applicable
Author

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

Regards,

My

JonnyPoole
Employee
Employee

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.

Not applicable
Author

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

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

 

MarcoWedel

if you're looking for tomorrow:

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


hope this helps


regards


Marco

View solution in original post

Not applicable
Author

Worked beautifully!

MarcoWedel

you're welcome

regards

Marco