Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: Using the Now or Today

if you're looking for tomorrow:

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


hope this helps


regards


Marco

7 Replies
jpe
Not applicable

Re: Using the Now or Today

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

=date(today()+1)

Not applicable

Re: Using the Now or Today

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

Regards,

My

jpe
Not applicable

Re: Using the Now or Today

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

Re: Using the Now or Today

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

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

 

MarcoWedel
Not applicable

Re: Using the Now or Today

if you're looking for tomorrow:

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


hope this helps


regards


Marco

Not applicable

Re: Using the Now or Today

Worked beautifully!

MarcoWedel
Not applicable

Re: Using the Now or Today

you're welcome

regards

Marco