I need to format the Date field in the dataset, not the analysis/visual. I see posts referencing the “Edit Date Format” option as follows:
But I don’t have that option…
Any assistance would be greatly appreciated!
HI @toddc
me too but depends on the dataset. csv doenst work but joined dataset does.
You could change it to string and back to date.
BR
I am using a custom SQL query of a Postgres RDS DB.
Unmodified value looks like:
Converting to string and back to date with… to_char(dev.created, 'YYYY-MM-DD')::date "Creation Date"
What I need is the following as a Date and not a String:
Hi @toddc,
Checking in here as it’s been awhile since last communication took place on this thread; are you still working on this case or were you able to find a work around in the interim?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you
This was the answer I got from my support ticket:
Unfortunately, QuickSight doesn’t provide a direct way to eliminate the timestamp from a date-timestamp field in the exported CSV data while keeping it as a date type. However, I can suggest a workaround to achieve your desired result:
Create a new calculated field in QuickSight using the following formula:
formatDate({your_original_date_column}, ‘yyyy-MM-dd’)
This new field will be a string type, containing only the date in ‘YYYY-MM-DD’ format. Include this new calculated field in your visual and use it for the CSV export.