topic Re: Date Format DD.MM.YY to DD.MM.YYYY in App Development

Date Format DD.MM.YY to DD.MM.YYYY

pamaxeed — Tue, 17 Apr 2018 08:53:21 GMT

Hi guys,

I have an issue when I am loading thd data from the source System (Oracle).

All dates and timestamp format are delivered with the YY Format for the year.

When trying to change the format in Qlikview to DD.MM.YYYY the data are interpret wrong:

e.g. 07.03.10 13;04:00 to 07.03.0110

Should be => 07.03.2010 ...

What I can do to adjust it to the right format?

Thanks,

Patric

Re: Date Format DD.MM.YY to DD.MM.YYYY

sunny_talwar — Tue, 17 Apr 2018 08:54:42 GMT

May be this

Date(DateField, 'DD.MM.YYYY') as Date

Date(Date#(DateField, 'DD.MM.YY'), 'DD.MM.YYYY') as Date

Re: Date Format DD.MM.YY to DD.MM.YYYY

pamaxeed — Tue, 17 Apr 2018 09:01:31 GMT

Nope.

Please note i have a timestamp format:

e.g. 28.02.10 13:04:00

Re: Date Format DD.MM.YY to DD.MM.YYYY

sunny_talwar — Tue, 17 Apr 2018 09:04:29 GMT

May be this

Date(Floor(TimeStamp#(DateField, 'DD.MM.YY hh:mm:ss')), 'DD.MM.YYYY') as Date

Re: Date Format DD.MM.YY to DD.MM.YYYY

ErikWetterberg — Tue, 17 Apr 2018 09:20:49 GMT

Haven't worked with Oracle for some time, but you used to be able to get rid of the time part with just Trunc(field).

Erik Wetterberg

Re: Date Format DD.MM.YY to DD.MM.YYYY

pamaxeed — Tue, 17 Apr 2018 18:02:42 GMT

Still not solved. Very strange behaviour!

In SQL Developer the only way to get the right field for those field is using the RRRR format which means:

RRRR format means 2-digit years in the range 00 to 49 are assumed to be in the current century (ie have the same first two digits as the current year), and years given as 50 through 99 are assumed to be in the previous century.

But it is not completely right for every cases.

The DWH guys are looking for the issue more deeply.

I will let you know.

Thanks,

Patric