Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

String from excel to date in Qlikview

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.

12 Replies
maxgro
MVP
MVP

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


if the excel format is different from YYYYMMDD, change it

sujeetsingh
Master III
Master III

Please post sample

Not applicable
Author

Thank you all for assistance