topic Re: how handle dates problem in QlikView

how handle dates problem

Anonymous — Mon, 03 Aug 2015 13:45:47 GMT

I have a variable date which is initially 20151231

I always got this date initial as the following picture

I feel confused , is there a way to resolve it ?

Re: how handle dates problem

marcus_sommer — Mon, 03 Aug 2015 15:37:41 GMT

Your variable-value won't be recognized as date. If you creates the variable use a format-function, something like this:

let vFromDate = date(date#(20151231, 'YYYYMMDD'));

- Marcus

Re: how handle dates problem

saurabh5 — Mon, 03 Aug 2015 17:48:55 GMT

hi ,

for all date variables use date functions to convert to appropriate format, so that you can use thee variable in calender object and also it will be easy to do any calculations to calcute time period.

Regards