I have a dataset with the follow string format for all of the dates: 2023-11-17 13:26:49 UTC
When I try to simply right click and convert the field to date, I get this error:
I need to the data type in date format for filtering options.
I have a dataset with the follow string format for all of the dates: 2023-11-17 13:26:49 UTC
When I try to simply right click and convert the field to date, I get this error:
I need to the data type in date format for filtering options.
Hello @Jrvish !
Could you try making this a calculated field on your data prep layer using parseDate?
Hi @Jrvish,
On the edit date format view, can you put in the below date format and let us know if it works for you.
yyyy-MM-dd HH:mm:ss ZZZ
Kind regards,
Liv
I tried it and it validates, but then throws an error when I try to apply it. Here are some screen shots:
I might be doing the format portion wrong, but these are the two that I attempted but an’t get them to go through without errors:
Hello @Jrvish !
Can you try it without the brackets ?
So try this:
parseDate({Action Date}, 'yyyy-MM-ddTkk:mm:ss.SSSZ')
Let me know if that works!
Just tried it, a few times and even closed QuickSight and reopened it just in case, and this is the error that I keep getting:
Ok, sorry. I just ran it with the other format and your way without the brackets worked! Of course it had to be that simple… Haha thanks for the help!