Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Qlikview and I'm struggling with a .csv import and date/time conversions.
My string field value: Mon, August 31, 2020 01:15:20.000
I've tried the following without success:
=date(timestamp#('MyDateTimeStampField', 'WWW, MMM DD, YYYY hh:mm:ss[.fff]'), 'YYYY/MM/DD')
=date(timestamp#('MyDateTimeStampField', 'WWW, MMM DD, YYYY hh:mm:ss.fff'), 'YYYY/MM/DD')
=date(timestamp#('MyDateTimeStampField', 'WWW, MMM DD, YYYY h:mm:ss.fff'), 'YYYY/MM/DD')
Can someone help me with what I'm doing wrong?
MMM is the format code for the short month name, Aug. Try MMMM to get August.
It's not the MMM DD, YYYY hh:mm:ss.fff I'm having a problem with. That works if I remove the "Mon,", It seems to be the WWW part that is giving me issues.
To Clarify:
This Works:
=date(timestamp#('August 31, 2020 01:15:20.000','MMM DD, YYYY hh:mm:ss.fff'), 'YYYY/MM/DD')
This does not Work and what I'm trying to get to work:
=date(timestamp#('Mon, August 31, 2020 01:15:20.000', 'WWW, MMM DD, YYYY hh:mm:ss.fff'), 'YYYY/MM/DD')
also tried this and doesn't work.
=date(timestamp#('Mon, August 31, 2020 00:00:00.000','WWW, MMMM DD, YYYY hh:mm:ss.fff'), 'YYYY/MM/DD')
Any help on this from anyone? going on day 5 of trying to figure this out 😞
Would recommend reviewing the following Help link as to what is actually supported with the function and the formatting required. I suspect the commas are the issue from what I can tell.
Regards,
Brett