Date Variable

[danielnevitt]

Hi,

I have a script that where I state the following:

where tl.final_pricing_dt > '2016-08-29'

Is it possible to replace the date with a variable for yesterday?

Thanks,

Daniel

[sunny_talwar]

Sure, may be like this:

LET vDate = Date(MakeDate(2016, 8, 29), 'YYYY-MM-DD');

Where tl.final_pricing_dt > '$(vDate)';

[#3]

Hi,

vYesterday=Today()-1

Thanks,

Nitin

[danielnevitt]

Thanks for the reply.

Will that create a moving date?  For example if I run the report tomorrow I would like the date to be today.

ie Run on 01/09/2016 and pricing greater than 31/08/2016.

Regards,

Daniel

[sunny_talwar]

May be this:

LET vDate = Date(Today() - 1, 'YYYY-MM-DD');

Where tl.final_pricing_dt > '$(vDate)';

[#6]

Yes , Today() function gives you today's date every time you open or reload the qvw .

Thanks

Nitin

[Chanty4u]

try lik

let vdate=Date(Today()-1,'YYYY-MM-DD');

[test]:

LOAD * INLINE [

Maand, ID, myDate

1, 2, 2014-12-14

2, 3,2016-09-15

]

Where myDate>'$(vdate)';