Convert String to Date Type

Question & Answer
, ,
1

Hi, I’m trying to convert a string data field into a date field. I tried doing the three dots and changing the data type but I kept getting an error. I’ve also tried using a calculated field ParseDate function with no success as all rows get skipped.

Below is an example of how the string looks that I’m trying to convert. The data is coming from a Glue table.

image

Any help would be greatly appreciated.

Thanks

2

Hi @B_Einstein - Welcome to AWS QuickSight community and thanks for posting the question. One of the solution approach you can follow -

  1. Use substring and extract he date part - See the below link for the documentation
    Substring - Amazon QuickSight
  2. Then use parsedate function to parse the string to date , maintain the format as per your substring output

Regards - Sanjeeb

3

Hi @B_Einstein … try here Difference between Dates which are in String Format