topic Re: Date Field Timestamp Convertion with date yyyy-mm-dd format in QlikView

Date Field Timestamp Convertion with date yyyy-mm-dd format

vikasmahajan — Mon, 05 Jun 2017 13:25:04 GMT

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

sunny_talwar — Mon, 05 Jun 2017 13:27:34 GMT

Format doesn't matter for where statement within QlikView as long as QlikView interpret it as date... try this

Date#(Left(vBackDateStart, 8), 'YYYYMMDD')

sunny_talwar — Mon, 05 Jun 2017 13:28:08 GMT

or if you really want the format, then may be this

=Date(Date#(Left(vBackDateStart, 8), 'YYYYMMDD'), 'YYYY-MM-DD')