topic Date Problem in QlikView

Date Problem

krishna20 — Wed, 06 May 2015 05:13:57 GMT

Hi Folks,

I'm trying to do arbitrary date ranges.My database date is not converting to right formatted one. I need to use converted date in the calendar objects. when i'm using this date in the calendar objects,its not working.But, database date is working perfect.Please,anyone suggest me how to achieve this one. Please find the sample app.

Re: Date Problem

Gysbert_Wassenaar — Wed, 06 May 2015 05:57:46 GMT

I've added two variables to change the date format of the values. I've used these two new variables in the Select in Field search string. See attached qvq.

You can also define the default date format for the document in the script using the DateFormat variable. Change it from SET DateFormat='M/D/YYYY'; to SET DateFormat='DD-MM-YYYY';

Note that your date field does not contain dates, but timestamps. You may want to cut off the time part using the floor function: DATE(floor(TP_APPR_DT),'DD-MM-YYYY')as POL_APPR_DATE

Re: Date Problem

krishna20 — Wed, 06 May 2015 05:58:05 GMT

Hi Friends,

Any Idea about this issue !!!

Re: Date Problem

krishna20 — Wed, 06 May 2015 06:53:16 GMT

Thank you very much Gysbert.