Issue in formatting date field in CSV file.

[#1]

Hello Community,

I have uploaded below excel (csv) file into Qlik. I am trying to format Column Trim(A) as date but it doesn't work.

I am using Date(A) but below is the result. It removes some values. How can I format as MM/DD/YYYY. I have tried Date(, 'MM/DD/YYYY')  but still gives below result. Somehow it is not able to identify that column as dat...

Thanks,

[hic · Accepted solution]

You have it in DD/MM/YYYY and you want it in MM/DD/YYYY.

Date(Date#( Field, 'DD/MM/YYYY'), 'MM/DD/YYYY')

See QlikView Date fields

HIC

[Gabriel]

Hi,

As hic said above, your DATE# function is how the date fields are coming into QlikView and your Date() function outside that is how you want to present the date.

[MayilVahanan]

Hi

Try like this

LOAD *, Alt(Date(A), date(Date#(A ,'DD/MM/YYYY'),'DD/MM/YYYY')) as A1;

LOAD [PO No.],

     A,

     B,

     C,

     D

FROM

Factory_FORTSrg.xls

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq);

[#5]

Thanks Henric it worked!