Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Date(Date#(MID(FIELDNAME,34,8), 'YYYYMMDD')) AS DATEFIELD
if the excel format is different from YYYYMMDD, change it
Please post sample
Thank you all for assistance