csv import and date/time conversions with WWW

[angmarceau1971]

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?

[jwjackso]

MMM is the format code for the short month name, Aug.  Try MMMM to get August.

[angmarceau1971]

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.

[angmarceau1971]

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')

[angmarceau1971]

Any help on this from anyone?  going on day 5 of trying to figure this out 😞

[Brett_Bleess]

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.  

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/conventions-num...

Regards,
Brett