Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
You have it in DD/MM/YYYY and you want it in MM/DD/YYYY.
Date(Date#( Field, 'DD/MM/YYYY'), 'MM/DD/YYYY')
HIC
You have it in DD/MM/YYYY and you want it in MM/DD/YYYY.
Date(Date#( Field, 'DD/MM/YYYY'), 'MM/DD/YYYY')
HIC
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.
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);
Thanks Henric it worked!