Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm using excel file as data source with date as one of the column. This date fields had mixed format type for example 14/2/2014 (date format) and 15-2-2014(General format). Is there a way to convert all the dates to one format at Qlikview level ?
Thanks in Advance
Thanks
Vardhan
Hi Vardhan,
Use this in load script
Date(Date#(PurgeChar(DateField,'/-.'),'DDMMYYYY'),'DD-MM-YYYY') as NewDate
Regards,
Sokkorn
Hi Vardhan,
Use this in load script
Date(Date#(PurgeChar(DateField,'/-.'),'DDMMYYYY'),'DD-MM-YYYY') as NewDate
Regards,
Sokkorn
hi
try this
date(date#(fieldname,'DD/MM/YYYY'),'DD-MM-YYYY')