Dynamic Date

[#1]

Hi All,

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

Thanks

[#2]

Expression:

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

[tresesco]

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.

[Anonymous]

Here you go

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

[#5]

Never Mind, Figured it Out...

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

[anbu1984]

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