Can anyone help me with how I go about changing the string in the screenshot above into a date format quicksight can understand and use? (e.g “Fri, 02 Dec 2022 09:59:38.699 GMT+0000”)
We also have columns that hold a unix timestamp (e.g. 1675239632402) - can anyone help with how we go about converting these into usable datetime for quicksight to use?
So I am guessing I could potentially use calculated field to take my other date formats (“Wed, 25 Jan 2023 15:16:56.138 GMT+0000”) to also convert if I do some string manipulation first?