# Can't Find "Edit Date Format" in Dataset

**URL:** <https://community.amazonquick.com/t/cant-find-edit-date-format-in-dataset/43922>\
**Category:** Q&A\
**Tags:** data-source, Business-Intelligence-Engineer, formatting, quick-sight\
**Created:** [March 19, 2025, 4:11pm UTC](https://community.amazonquick.com/t/cant-find-edit-date-format-in-dataset/43922 "2025-03-19T16:11:11Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![toddc](https://avatars.discourse-cdn.com/v4/letter/t/8dc957/32.png) [@toddc](https://community.amazonquick.com/u/toddc)\
**Post date:** [March 19, 2025, 4:11pm UTC](https://community.amazonquick.com/t/cant-find-edit-date-format-in-dataset/43922/1 "2025-03-19T16:11:11Z")

</div>

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:

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/0/d/0daaa08d01cb1c7e48effa147c8050fd3a114eda.png)

But I don’t have that option…

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/2/a/2a32765197c2c99e3ce45225fe20e97c8ec93664.png)

Any assistance would be greatly appreciated!

---

<div class="post-metadata">

**Author:** ![ErikG](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/erikg/32/14524_2.png) [@ErikG](https://community.amazonquick.com/u/ErikG)\
**Post date:** [March 19, 2025, 4:22pm UTC](https://community.amazonquick.com/t/cant-find-edit-date-format-in-dataset/43922/2 "2025-03-19T16:22:06Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![toddc](https://avatars.discourse-cdn.com/v4/letter/t/8dc957/32.png) [@toddc](https://community.amazonquick.com/u/toddc)\
**Post date:** [March 19, 2025, 6:01pm UTC](https://community.amazonquick.com/t/cant-find-edit-date-format-in-dataset/43922/3 "2025-03-19T18:01:10Z")

</div>

I am using a custom SQL query of a Postgres RDS DB.

Unmodified value looks like:

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/7/7/777578e36592034feef7fe24e71d91b9fd5bb226.png)

Converting to string and back to date with… `to_char(dev.created, 'YYYY-MM-DD')::date "Creation Date"`

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/b/2/b2481e747ce8970c56f8a37ae7e4a251fe2f32df.png)

What I need is the following as a Date and not a String:

 ![image](https://d1wl4jav5dp96l.cloudfront.net/original/3X/a/3/a3d288258d589ba10b20dc4caea654e3c7a9ce59.png)

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [April 14, 2025, 3:19pm UTC](https://community.amazonquick.com/t/cant-find-edit-date-format-in-dataset/43922/4 "2025-04-14T15:19:37Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![toddc](https://avatars.discourse-cdn.com/v4/letter/t/8dc957/32.png) [@toddc](https://community.amazonquick.com/u/toddc)\
**Post date:** [April 14, 2025, 3:36pm UTC](https://community.amazonquick.com/t/cant-find-edit-date-format-in-dataset/43922/5 "2025-04-14T15:36:59Z")

</div>

This was the answer I got from my support ticket:

_Unfortunately, Quick Sight 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 Quick Sight 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._

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [April 22, 2025, 6:47pm UTC](https://community.amazonquick.com/t/cant-find-edit-date-format-in-dataset/43922/6 "2025-04-22T18:47:35Z")

</div>

Hi @toddc,  
Thanks for sharing! And did that work for your case as a potential work around?