String from excel to date in Qlikview

[#1]

Hi there,

I am trying to convert the following string from excel to a date value in Qlikview in the edit script as such:

DATE(MID(FIELDNAME,34,8), 'YYYY/MM/DD') AS DATEFIELD

However, it is not returning any values.

Could anyone be of assistance please?

Than you.

[maxgro · Accepted solution]

Date(Date#(MID(FIELDNAME,34,8), 'YYYYMMDD')) AS DATEFIELD

if the excel format is different from YYYYMMDD, change it

[sujeetsingh]

Please post sample

[#4]

Thank you all for assistance