topic Re: Using the Now or Today in QlikView

Using the Now or Today

Fri, 03 Oct 2014 16:16:15 GMT

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,

JonnyPoole — Fri, 03 Oct 2014 16:17:36 GMT

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

=date(today()+1)

Fri, 03 Oct 2014 16:19:34 GMT

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

Regards,

JonnyPoole — Fri, 03 Oct 2014 16:22:52 GMT

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.

Fri, 03 Oct 2014 16:43:47 GMT

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

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

MarcoWedel — Fri, 03 Oct 2014 16:59:35 GMT

if you're looking for tomorrow:

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

hope this helps

regards

Marco

Fri, 03 Oct 2014 19:10:56 GMT

Worked beautifully!

MarcoWedel — Fri, 03 Oct 2014 19:14:54 GMT

you're welcome

regards

Marco