topic Date Import Issue Import Data is formated: DD.MM.YYYY in QlikView

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

Tue, 10 Jan 2012 22:13:18 GMT

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?

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

Tue, 10 Jan 2012 22:46:53 GMT

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

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

vijay_iitkgp — Wed, 11 Jan 2012 08:03:05 GMT

Hi Marek,

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

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

Miguel_Angel_Baeyens — Wed, 11 Jan 2012 08:42:19 GMT

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

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

Thu, 17 Sep 2015 13:21:20 GMT

It Works a lot!!! tks