Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

pamaxeed
Contributor III

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

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

Tags (1)
5 Replies
MVP
MVP

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

May be this

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

or

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

pamaxeed
Contributor III

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

Nope.

Please note i have a timestamp format:

e.g. 28.02.10 13:04:00

MVP
MVP

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

May be this

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

erik_wetterberg
Valued Contributor III

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

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

Erik Wetterberg
https://extendingqlik.upper88.com/
pamaxeed
Contributor III

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

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


Community Browser