I have an Excel based DataSet that I am trying to recreate with a CSV in S3 … I’m manually trying to recreate the dataset meta data but I’m running into issues with dates. I’m trying to use the same date format from my Excel Based dataset (left side) with my CSV in S3 dataset (right side)
I believe this happens because there are no rows to validate against it (i.e they are all null in the preview).
You can manually create a parseDate calculation in the dataset that will take that column and cast it to a date.
Or, if you have it in S3 I would suggest looking to Athena as you can use SQL on your CSVs that can convert this as a date format before it loads into quicksight.
Though from a product perspective does it make sense to still allow us to still persist the date format configuration … maybe with a warning stating what the problem is.
I definitely agree. I will mark this as a feature request. I believe there is an old question about this in the forum, but will make sure to mark this a feature request again.