Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Date format..

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

Tags (2)
1 Solution

Accepted Solutions
Sokkorn
Honored Contributor

Re: Date format..

Hi Vardhan,

Use this in load script

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

Regards,

Sokkorn

2 Replies
Sokkorn
Honored Contributor

Re: Date format..

Hi Vardhan,

Use this in load script

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

Regards,

Sokkorn

Not applicable

Re: Date format..

hi

try this

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

Community Browser