topic Re: Date Format Issue in QlikView

Date Format Issue

alec1982 — Wed, 30 Jul 2014 16:01:55 GMT

Hi guys,

I am having date format issue while loading. the dates are readable in excel but when I apply Date() within the script I get Null values.

Hope someone can help. I attached the source file..

Best,

Alec

joshabbott — Wed, 30 Jul 2014 16:06:58 GMT

Try Date#()

rustyfishbones — Wed, 30 Jul 2014 16:16:27 GMT

Hi try the following

maxgro — Wed, 30 Jul 2014 16:35:48 GMT

Directory;

LOAD ID, Ref, [Option Type], [Option Type Description],

[Break Date], [Maximum Notice Date], [Minimum Notice Date],

[Break Term], Comments,

date(Date#([Break Date], 'DD-MMM-YYYY')) as newdate

FROM Options.csv (txt, codepage is 1252, embedded labels, delimiter is ',', msq);