topic Re: Displaying Date Field on Dashboard Issue in QlikView

Displaying Date Field on Dashboard Issue

Fri, 14 Nov 2014 14:46:48 GMT

Hi,

Why is my DATE field YEAR showing 1899, 1900 and so on... ??

Pls Need Help !!

Re: Displaying Date Field on Dashboard Issue

ashfaq_haseeb — Fri, 14 Nov 2014 14:49:23 GMT

Hi,

I think you have some hijri or roman dates.

Can you post some 4 to 5 lines of data from database to look over.

Regards

ASHFAQ

Re: Displaying Date Field on Dashboard Issue

jpenuliar — Fri, 14 Nov 2014 14:55:17 GMT

See, if you Field is formatted 'MM/DD/YYYY'

Re: Displaying Date Field on Dashboard Issue

its_anandrjs — Fri, 14 Nov 2014 15:11:47 GMT

Hi,

Your date format is not correct let me know the snap is direct from the source or after the source or you can do set the date format according to your use or format date in proper order

SET DateFormat='MM/DD/YYYY';

Date(YourDateField,'MM/DD/YYYY') as DateField

Regards

Anand

Re: Displaying Date Field on Dashboard Issue

Fri, 14 Nov 2014 15:19:51 GMT

I did this in my script editor but still i am getting Year as 1900.

Date(Dlv.Date ,'MM/DD/YYYY') as [Delivery DATE],

Here is my source date format.