Date format issue

[Anonymous]

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.

[bbi_mba_76]

Hi,

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

[#3]

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

[Greg_Williams]

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

-Greg

[its_anandrjs]

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.

[Anonymous]

Thanks a lot guys that was very helpful .

[rbecher]

You probably have the wrong date format settings?

Wrong:

SET DateFormat='MM/DD/YYYY';

Right:

SET DateFormat='DD/MM/YYYY';