Date format..

[#1]

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

[Sokkorn · Accepted solution]

Hi Vardhan,

Use this in load script

Date(Date#(PurgeChar(DateField,'/-.'),'DDMMYYYY'),'DD-MM-YYYY') as NewDate

Regards,

Sokkorn

[#3]

hi

try this

date(date#(fieldname,'DD/MM/YYYY'),'DD-MM-YYYY')