Date Import Issue Import Data is formated: DD.MM.YYYY

[#1]

Hi Everyone,

Does QlikView support importing dates in DD.MM.YYYY hh:mm:ss where the seperator is a period?  I have an excel file that has the timestamp in this format. I cannot get qlikview to import it as such. 

Any ideas?

[#2]

Ok apparently QlikView does not like dates parsed with a period. I did this quick test:

Date(DayStart('2011.02.25 18:03:41'), 'DD MMM YY') as TestDate

Returns nothing

Date(DayStart('2011/02/25 18:03:41'), 'DD MMM YY') as TestDate

works like a charm

[vijay_iitkgp]

Hi Marek,

If you can set your date format in main tab as YYYY.MM.DD and then reload the application. It will work.

[Miguel_Angel_Baeyens · Accepted solution]

Hi Marek,

Indeed, the dates are very sensitive, but that what Date#() or Timestamp#() (note the pound sign) is for:

Date(DayStart(Timestamp#('2011.02.25 18:03:41', 'YYYY.MM.DD hh:mm:ss')), 'DD MMM YY') as TestDate

This will work fine. The "#" functions are used to interpret unknown values to proper Date, Num, Money... values.

Hope that helps.

Miguel

[#5]

It Works a lot!!! tks