Date Format Issue

[alec1982]

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]

Try Date#()

[rustyfishbones]

Hi try the following

[maxgro]

Directory;

d:

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);