topic Re: Date format issue in QlikView

Date format issue

Anonymous — Tue, 06 May 2014 13:00:58 GMT

Hi,

I am struggling with a date format, F_EOD is the formatted date eg.Date() or Date#(). Each time i wrap a function being it Date,Year,Month the field goes empty.R_EOD is the raw fieldname unformatted.

Please help.

Re: Date format issue

bbi_mba_76 — Tue, 06 May 2014 13:03:39 GMT

Hi,

did you try using the format 'DD/MM/YYYY' in your application?

Re: Date format issue

Tue, 06 May 2014 13:04:39 GMT

Let Qlikview know it is a date field by doing Date#(R_EOD, 'DD/MM/YYYY').

Re: Date format issue

Greg_Williams — Tue, 06 May 2014 13:17:28 GMT

date(date#(F_EOD,'DD/MM/YYYY'))

-Greg

Re: Date format issue

its_anandrjs — Tue, 06 May 2014 13:29:45 GMT

Load the fields as

Date#(F_EOD) as F_EOD

and check in qlikview what you get may be it is 41234 some thing like this value then convert it into your date format.

Re: Date format issue

Anonymous — Tue, 06 May 2014 13:30:21 GMT

Thanks a lot guys that was very helpful .

Re: Date format issue

rbecher — Tue, 06 May 2014 13:34:09 GMT

You probably have the wrong date format settings?

Wrong:

SET DateFormat='MM/DD/YYYY';

Right:

SET DateFormat='DD/MM/YYYY';