topic Date function not working on all data in QlikView

Date function not working on all data

Thu, 26 Apr 2012 18:17:02 GMT

I have data that represents a date in the format 'YYMMDD' and I am converting it to a readable date format of 'MM/DD/YYYY' with the following script:

This is working for most of the dates but there are a few that are not coming over in the correct format:

The 040806 toward the end should be coming in as 10/11/2011 and the 040623 at the bottom should be 03/21/11. Any thoughts on why this works on some but not others?

Date function not working on all data

mphekin12 — Thu, 26 Apr 2012 18:21:40 GMT

Have you tried something like this in the load script:

timestamp(OriginalDate,'M/D/YYYY h:mm:ss[.fff] TT') as OriginalDate,

Date function not working on all data

CELAMBARASAN — Thu, 26 Apr 2012 18:23:13 GMT

Hi,

Its better to use like below

Date(Date#(OriginalDate,'YYMMDD'),'MM/DD/YYYY') as OriginalDate

Celambarasan