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

[pamaxeed]

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

[sunny_talwar]

May be this

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

or

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

[pamaxeed]

Nope.

Please note i have a timestamp format:

e.g. 28.02.10 13:04:00

[sunny_talwar]

May be this

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

[ErikWetterberg]

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

[pamaxeed]

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