Date format String

My source stores Date in the following format: Tue Feb 27 00:00:00 UTC 2024

Having difficulties getting QuickSight parse. Please help.

Hi @sjsk, welcome to the QuickSight Community, try using the following function:

parseDate({EventDate}, 'EEE MMM dd HH:mm:ss z yyyy')

In case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)

Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!