Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have variable vMaxDate which hold max value of date from QVD. I want to check backdated -12 months in this variable like this
vBackDateMonths = -12;
I have backdatestart like this
LET vBackDateStart = TimeStamp(MonthEnd(AddMonths(DATE(Floor(vMaxDate),'YYYYMMDD'),$(vBackDateMonths))),'YYYYMMDDhhmmss');
which gives me this value which is correct 20160531235959
Now in transaction my Reporting_Dt is in ÝYYY-MM-DD format how to convert the into ÝYYY-MM-DD' format ?
Vikas
Sunny : Can you please check this qvw I am not able to get the records
Vikas
Format doesn't matter for where statement within QlikView as long as QlikView interpret it as date... try this
Date#(Left(vBackDateStart, 8), 'YYYYMMDD')
or if you really want the format, then may be this
=Date(Date#(Left(vBackDateStart, 8), 'YYYYMMDD'), 'YYYY-MM-DD')