topic Re: Date Format in QlikView in QlikView

Date Format in QlikView

Wed, 27 May 2015 05:40:30 GMT

I am using the oracle query. what date format qlikview accept?

Re: Date Format in QlikView

sunny_talwar — Wed, 27 May 2015 15:14:14 GMT

QlikView should be able to load in any date format. In case it is unable to read a specific date as date you can force it to understand it using Date#() function

Date#(DateField, 'DateField's Date Format') as Date

Best,

Sunny

Re: Date Format in QlikView

maxgro — Wed, 27 May 2015 15:23:28 GMT

first try without any format / interpretation function

ie in my environment I get a Qlik timestamp from an Oracle date (DAY_DATE) without any interpretation function

SQL SELECT

DAY_DATE

FROM TEST.TEST

;