topic Calendar Date Issue in QlikView

Calendar Date Issue

Wed, 27 Nov 2013 04:58:35 GMT

Hi,

I am using two calendar objects from variables vFromDate and vToDate:

Instead of Date format ,i am getting in number format.

i used Date function but with next select its getting changed to number.

How to dipslay the date in calendar as DATE and not as a number{37573,41585}

nilesh_gangurde — Wed, 27 Nov 2013 05:06:06 GMT

Hii,

Covert your Date in the Date Format at Script Level.

Date(Date_Field) as Date

It will work.

-Nilesh

VishalWaghole — Wed, 27 Nov 2013 05:11:26 GMT

Hi Poornima,

Right click on calender object.

go to Number tab and change format as Date.

find attachment that will help you.

Thanks and Regards,

Vishal Waghle