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

Dynamic Date

Hi All,

Is there anyway that i can change this expression to automatically calculate 14 days back?

Thanks

5 Replies
Not applicable

Re: Dynamic Date

Expression:

let vFromDate=floor(Date#('2014-04-10','YYYY-MM-DD'));

MVP
MVP

Re: Dynamic Date

Not sure if understood right. May be like:

Let vBackDate=Num(Today()-14);    // now you can replace today() with any date. Integer 1 is equivalent to 1 day.

jebamalai
Valued Contributor

Re: Dynamic Date

Here you go

vFromDate=floor(Date#('2014-04-10','YYYY-MM-DD'))-14;

Not applicable

Re: Dynamic Date

Never Mind, Figured it Out...

let vFromDate=date(floor(today()-14))

anbu1984
Honored Contributor III

Re: Dynamic Date

Date(floor(Date#('2014-04-10','YYYY-MM-DD'))-14,'YYYY-MM-DD')

Community Browser