# \#date **URL:** https://community.amazonquick.com/tag/date/76.md [Latest](https://community.amazonquick.com/latest.md) · [Categories](https://community.amazonquick.com/categories.md) · [Tags](https://community.amazonquick.com/tags.md) --- ## [Date Period Toggle With Formatting](https://community.amazonquick.com/t/date-period-toggle-with-formatting/53661)
**Author:** [@aaron.wilson](https://community.amazonquick.com/u/aaron.wilson)\ **Replies:** 2\ **Last updated:** [September 15, 2026, 3:57am UTC](https://community.amazonquick.com/t/date-period-toggle-with-formatting/53661 "2026-09-15T03:57:53Z")
Hi, I am trying to create an Analysis with a date toggle which is also able to change date format based on each date period selected. I have a control setup to pick between daily, weekly, monthly or yearly which works w… --- ## [To hide " Select All " from a String - based date control](https://community.amazonquick.com/t/to-hide-select-all-from-a-string-based-date-control/53196)
**Author:** [@Ardra](https://community.amazonquick.com/u/Ardra)\ **Replies:** 7\ **Last updated:** [August 31, 2026, 5:45am UTC](https://community.amazonquick.com/t/to-hide-select-all-from-a-string-based-date-control/53196 "2026-08-31T05:45:12Z")
This Date Created filter is based on the parameter shown above , and the parameter is connected to a calculated field (where the current month is excluded and only previous months are displayed). Also that calcula… --- ## [How to create one date filter to apply for two different dates in two different data sets](https://community.amazonquick.com/t/how-to-create-one-date-filter-to-apply-for-two-different-dates-in-two-different-data-sets/20465)
**Author:** [@madsdental](https://community.amazonquick.com/u/madsdental)\ **Replies:** 4\ **Last updated:** [April 22, 2026, 2:13pm UTC](https://community.amazonquick.com/t/how-to-create-one-date-filter-to-apply-for-two-different-dates-in-two-different-data-sets/20465 "2026-04-22T14:13:58Z")
Hi, I am trying to build up a dashboard with several visuals connected to individual datasets. I want to accomplish the following: Create one Date and Time range filter that is applicable to two different dates (dateti… --- ## [Should the week number include 2025 WK53?](https://community.amazonquick.com/t/should-the-week-number-include-2025-wk53/51290)
**Author:** [@coly](https://community.amazonquick.com/u/coly)\ **Replies:** 8\ **Last updated:** [March 12, 2026, 2:34pm UTC](https://community.amazonquick.com/t/should-the-week-number-include-2025-wk53/51290 "2026-03-12T14:34:01Z")
Should the week number include 2025 WK53 or directly jump to 2026 WK01, considering that January 1st, 2026 is a Thursday? --- ## [SQL\_SCHEMA\_MISMATCH\_ERROR - Unsupported Timestamp with Timezone in New DataPrep](https://community.amazonquick.com/t/sql-schema-mismatch-error-unsupported-timestamp-with-timezone-in-new-dataprep/51226)
**Author:** [@cosorio](https://community.amazonquick.com/u/cosorio)\ **Replies:** 3\ **Last updated:** [February 13, 2026, 12:15pm UTC](https://community.amazonquick.com/t/sql-schema-mismatch-error-unsupported-timestamp-with-timezone-in-new-dataprep/51226 "2026-02-13T12:15:16Z")
Since last week, we have been hit by the following error: SQL\_SCHEMA\_MISMATCH\_ERROR: Timestamp with timezone types are not supported. Incorrect Column Type at Index 1 for Column 'tested\_at' with DataprepLogicalType Date. … --- ## [Edit date format in the new experience of creating Datasets vs Old experience](https://community.amazonquick.com/t/edit-date-format-in-the-new-experience-of-creating-datasets-vs-old-experience/50863)
**Author:** [@praveen.gp](https://community.amazonquick.com/u/praveen.gp)\ **Replies:** 2\ **Last updated:** [December 9, 2025, 9:33pm UTC](https://community.amazonquick.com/t/edit-date-format-in-the-new-experience-of-creating-datasets-vs-old-experience/50863 "2025-12-09T21:33:24Z")
Hi all! I am trying to create a dataset with changing the datatype to date, for my analysis and the format of date is like: 2025-12-09T12:59:02.133692 : yyyy-MM-dd’T’HH:mm:ss.SSSSSS My requirement works with old versio… --- ## [Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)](https://community.amazonquick.com/t/period-over-period-and-other-date-comparison-calculations-yoy-mom-ytd-rolling-90-days-etc/564)
**Author:** [@Jesse](https://community.amazonquick.com/u/Jesse)\ **Replies:** 103\ **Last updated:** [November 24, 2025, 5:39pm UTC](https://community.amazonquick.com/t/period-over-period-and-other-date-comparison-calculations-yoy-mom-ytd-rolling-90-days-etc/564 "2025-11-24T17:39:28Z")
Often you may want to create tables and other visuals which display multiple fields that are all ‘filtered’ to different date periods, as well as period-over-period fields. However we can’t use normal filters for this si… --- ## [Week start day inconsistency between calculated field and filter in Quick Sight](https://community.amazonquick.com/t/week-start-day-inconsistency-between-calculated-field-and-filter-in-quick-sight/49964)
**Author:** [@arthurfsc](https://community.amazonquick.com/u/arthurfsc)\ **Replies:** 5\ **Last updated:** [October 23, 2025, 9:03am UTC](https://community.amazonquick.com/t/week-start-day-inconsistency-between-calculated-field-and-filter-in-quick-sight/49964 "2025-10-23T09:03:50Z")
Hi everyone, I’ve recently updated my Quick Sight analysis to start the week on Monday. To achieve this, I created a calculated field that returns the start of the week. When I add this calculated field to a visual, it… --- ## [Bug on date filter (end date 1 day beyond)](https://community.amazonquick.com/t/bug-on-date-filter-end-date-1-day-beyond/50007)
**Author:** [@onelag](https://community.amazonquick.com/u/onelag)\ **Replies:** 3\ **Last updated:** [October 8, 2025, 4:07pm UTC](https://community.amazonquick.com/t/bug-on-date-filter-end-date-1-day-beyond/50007 "2025-10-08T16:07:08Z")
Hello folks! I have a question about the date filters. I work for a client in finance, and use quicksight on a daily basis to report on transactions made by the clients. I have a set up a date filter on the dashboard, … --- ## [Converting UTC Timestamp in AWS Athena to Timestmap in time zone europe/berlin](https://community.amazonquick.com/t/converting-utc-timestamp-in-aws-athena-to-timestmap-in-time-zone-europe-berlin/49633)
**Author:** [@Markus](https://community.amazonquick.com/u/Markus)\ **Replies:** 4\ **Last updated:** [September 11, 2025, 7:11am UTC](https://community.amazonquick.com/t/converting-utc-timestamp-in-aws-athena-to-timestmap-in-time-zone-europe-berlin/49633 "2025-09-11T07:11:59Z")
Hi, I have a columen rwk\_date which is a timestamp where a utc time ist stored. I want to create another column for the local time. The local time is in time zone Europe/Berlin. My Approach was the following: rwk\_date… --- ## [Difference of 'This day' and 'Till day' in the Relative Date filters](https://community.amazonquick.com/t/difference-of-this-day-and-till-day-in-the-relative-date-filters/48982)
**Author:** [@praveen.gp](https://community.amazonquick.com/u/praveen.gp)\ **Replies:** 4\ **Last updated:** [August 29, 2025, 3:18pm UTC](https://community.amazonquick.com/t/difference-of-this-day-and-till-day-in-the-relative-date-filters/48982 "2025-08-29T15:18:01Z")
I’m trying to understand the difference between the ‘This Day’ and ‘Till Day’ options when using a relative date filter in Quick Sight. When I set ‘Relative by’ to ‘Days’ and select ‘This Day’, I get results for the cu… --- ## [Dealing with Start and enddate](https://community.amazonquick.com/t/dealing-with-start-and-enddate/48837)
**Author:** [@prateek\_san](https://community.amazonquick.com/u/prateek_san)\ **Replies:** 3\ **Last updated:** [August 27, 2025, 5:10pm UTC](https://community.amazonquick.com/t/dealing-with-start-and-enddate/48837 "2025-08-27T17:10:15Z")
I have a dataset that includes start\_date and end\_date for a job—similar to an HR dataset. For example, if a job was posted on February 1st and expired on December 1st, it was active across all months from February throu… --- ## [Convert String to Supported Date Format](https://community.amazonquick.com/t/convert-string-to-supported-date-format/49446)
**Author:** [@kobrien](https://community.amazonquick.com/u/kobrien)\ **Replies:** 3\ **Last updated:** [August 26, 2025, 1:50pm UTC](https://community.amazonquick.com/t/convert-string-to-supported-date-format/49446 "2025-08-26T13:50:53Z")
I’m having trouble converting several fields type string to type date. I verified there are no nulls or exceptions in my data. Here is an example here the date format is not able to be validated on conversion. Here is … --- ## [Data Preview Error in Quick Sight During Transformation](https://community.amazonquick.com/t/data-preview-error-in-quicksight-during-transformation/34021)
**Author:** [@isingla](https://community.amazonquick.com/u/isingla)\ **Replies:** 3\ **Last updated:** [July 17, 2025, 5:45pm UTC](https://community.amazonquick.com/t/data-preview-error-in-quicksight-during-transformation/34021 "2025-07-17T17:45:08Z")
While attempting to transform data related to shift timings in Amazon Quick Sight, specifically concerning breaks and slot timings, the following error occurred: No data available for preview. Details: Quick Sight fetc… --- ## [Week Numbers (1-53)](https://community.amazonquick.com/t/week-numbers-1-53/651)
**Author:** [@Jesse](https://community.amazonquick.com/u/Jesse)\ **Replies:** 15\ **Last updated:** [July 14, 2025, 9:01pm UTC](https://community.amazonquick.com/t/week-numbers-1-53/651 "2025-07-14T21:01:32Z")
Today the extract() function does not support extracting the ‘week number’ from a date field. As a workaround you can use a formula like this (may need some adjustments +/-1 for certain years, could add some ifElse logic… --- ## [Column headers formatting](https://community.amazonquick.com/t/column-headers-formatting/47606)
**Author:** [@krtse](https://community.amazonquick.com/u/krtse)\ **Replies:** 3\ **Last updated:** [July 10, 2025, 6:31pm UTC](https://community.amazonquick.com/t/column-headers-formatting/47606 "2025-07-10T18:31:42Z")
How to format date column header as MMM-Goal? I have date column which is aggregated as month and filtered for current month. I want the month to show as MMM-Goal. For eg: in June, the column should say ‘Jun-Goal’. Can… --- ## [Calendar Date Logic](https://community.amazonquick.com/t/calendar-date-logic/47591)
**Author:** [@Sree2025](https://community.amazonquick.com/u/Sree2025)\ **Replies:** 5\ **Last updated:** [July 10, 2025, 6:29pm UTC](https://community.amazonquick.com/t/calendar-date-logic/47591 "2025-07-10T18:29:14Z")
Hello Quick Sight’ers Fairly new to Quick Sight. I have a question on Calendar date. Is there an option in the Date Picker, when the calendar shows up it shows only until today’s date and masks the rest of the days. … --- ## [Showing Date Range as per Date Column](https://community.amazonquick.com/t/showing-date-range-as-per-date-column/47298)
**Author:** [@Venkat.Metadata](https://community.amazonquick.com/u/Venkat.Metadata)\ **Replies:** 7\ **Last updated:** [July 2, 2025, 6:48am UTC](https://community.amazonquick.com/t/showing-date-range-as-per-date-column/47298 "2025-07-02T06:48:48Z")
Hi QS team, I have a M\_Date Column Starts from Sep 1 2024 ( Start Date ) and End date ( depending on the last Date Let’s say May 1 2025 ) The Same column give in the Date Range Filter. I want to show Date Range… --- ## [How do I make a dynamic datetime axis on a graph?](https://community.amazonquick.com/t/how-do-i-make-a-dynamic-datetime-axis-on-a-graph/46999)
**Author:** [@zijingxu](https://community.amazonquick.com/u/zijingxu)\ **Replies:** 5\ **Last updated:** [June 23, 2025, 3:35pm UTC](https://community.amazonquick.com/t/how-do-i-make-a-dynamic-datetime-axis-on-a-graph/46999 "2025-06-23T15:35:15Z")
Hi all, How can you make a datetime x-axis dynamic? I have a calculated field displayed that only looks at the last 12 months from the current time, so it’s a moving calculation. I want the datetime axis to reflect this… --- ## [Help, help with calculated fields for date comparison](https://community.amazonquick.com/t/help-help-with-calculated-fields-for-date-comparison/47077)
**Author:** [@July](https://community.amazonquick.com/u/July)\ **Replies:** 3\ **Last updated:** [June 9, 2025, 2:20pm UTC](https://community.amazonquick.com/t/help-help-with-calculated-fields-for-date-comparison/47077 "2025-06-09T14:20:47Z")
Hi guys, I must created some calculated fields to compare datas. Could you help me, please? I thank you so much. Create calculated fields in Quick Sight to compute: The “current date” is not the system current date, … --- ## [Relative date picker in combination with datetime parameters](https://community.amazonquick.com/t/relative-date-picker-in-combination-with-datetime-parameters/17874)
**Author:** [@Liam](https://community.amazonquick.com/u/Liam)\ **Replies:** 8\ **Last updated:** [June 20, 2025, 11:16am UTC](https://community.amazonquick.com/t/relative-date-picker-in-combination-with-datetime-parameters/17874 "2025-06-20T11:16:33Z")
Hi I think the relative date picker when using a datetime filter is great. However, I have a dashboard that needs to use datetime parameters in the dataset to limit the rows returned, and have them mapped to controls in… --- ## [Backward Date](https://community.amazonquick.com/t/backward-date/47291)
**Author:** [@suvarna0212](https://community.amazonquick.com/u/suvarna0212)\ **Replies:** 5\ **Last updated:** [June 18, 2025, 3:22pm UTC](https://community.amazonquick.com/t/backward-date/47291 "2025-06-18T15:22:23Z")
hi, i am trying to use filter control over a column of birthdate.. but i cant select dates older than 20 years… as current years is 2025.. i can max see year till 2005. Please help on the same. --- ## [Joining Sales and Quota Data](https://community.amazonquick.com/t/joining-sales-and-quota-data/46655)
**Author:** [@Henirque\_Borges](https://community.amazonquick.com/u/Henirque_Borges)\ **Replies:** 5\ **Last updated:** [June 9, 2025, 7:23pm UTC](https://community.amazonquick.com/t/joining-sales-and-quota-data/46655 "2025-06-09T19:23:03Z")
i’m using Quicksight to create a BI for the Sales Department of my company. I aim to create a calculated field that shows the quota fulfillment and aply that on a KPI and on a Table that shows the information by Branch, … --- ## [\[HELP ! \] Why is it so difficult to create a rank?](https://community.amazonquick.com/t/help-why-is-it-so-difficult-to-create-a-rank/47078)
**Author:** [@July](https://community.amazonquick.com/u/July)\ **Replies:** 3\ **Last updated:** [June 8, 2025, 12:10pm UTC](https://community.amazonquick.com/t/help-why-is-it-so-difficult-to-create-a-rank/47078 "2025-06-08T12:10:18Z")
Hi guys I need to rank the highest financial value by month and category. I’ve been trying for a week, but without success. For example, I need to rank the highest value by category, and when I change the month, the ran… --- ## [extract('HH', timestamp) yielding weird results for some data](https://community.amazonquick.com/t/extract-hh-timestamp-yielding-weird-results-for-some-data/46575)
**Author:** [@davidqwi](https://community.amazonquick.com/u/davidqwi)\ **Replies:** 5\ **Last updated:** [June 5, 2025, 3:03pm UTC](https://community.amazonquick.com/t/extract-hh-timestamp-yielding-weird-results-for-some-data/46575 "2025-06-05T15:03:45Z")
calc field defined as: extract(‘HH’, {created\_date}) i can see that out of 17,000 records, about 30 of them yield results that are greater than 23. This should not be possible. It concerns me that many are wrong but I c… --- ## [Question: How to disable "Analyze Contributions" feature from Line / bar chart Quick Sight dashboards?](https://community.amazonquick.com/t/question-how-to-disable-analyze-contributions-feature-from-line-bar-chart-quicksight-dashboards/46748)
**Author:** [@Abhishek\_24](https://community.amazonquick.com/u/Abhishek_24)\ **Replies:** 1\ **Last updated:** [May 29, 2025, 6:39pm UTC](https://community.amazonquick.com/t/question-how-to-disable-analyze-contributions-feature-from-line-bar-chart-quicksight-dashboards/46748 "2025-05-29T18:39:55Z")
We’re using Amazon Quick Sight to embed dashboards into our product application. In both bar and line charts, users are seeing the “Analyze contributions” option (as shown in the attached screenshot), particularly when t… --- ## [When date range selected to 1st April to 28th april](https://community.amazonquick.com/t/when-date-range-selected-to-1st-april-to-28th-april/45386)
**Author:** [@Alam\_Syed](https://community.amazonquick.com/u/Alam_Syed)\ **Replies:** 8\ **Last updated:** [May 22, 2025, 3:55pm UTC](https://community.amazonquick.com/t/when-date-range-selected-to-1st-april-to-28th-april/45386 "2025-05-22T15:55:28Z")
Hi Team, my requirements is when date range is selected from 1st April to 28th April then display last 7 days, even when user select the previous month then also it should display last 7 days in KPIS. Is it possible to… --- ## [How to Always Show the Most Recent Week with Data](https://community.amazonquick.com/t/how-to-always-show-the-most-recent-week-with-data/46372)
**Author:** [@Nikhilburhade](https://community.amazonquick.com/u/Nikhilburhade)\ **Replies:** 6\ **Last updated:** [May 21, 2025, 3:43pm UTC](https://community.amazonquick.com/t/how-to-always-show-the-most-recent-week-with-data/46372 "2025-05-21T15:43:05Z")
Hello, We’re looking for a way to dynamically show the most recent week of data in Quick Sight, even when data for the latest calendar week is not available. Right now, when we use a rolling date filter like “Start of … --- ## [How to convert date format YYYYMMDDTHHmmss to YYYYMMDD in quicksight i have try using edit date formation it is taking it as buydefault that format only an with formatdate creating column i am getting that as string datatype i need it as date onl-y](https://community.amazonquick.com/t/how-to-convert-date-format-yyyymmddthhmmss-to-yyyymmdd-in-quicksight-i-have-try-using-edit-date-formation-it-is-taking-it-as-buydefault-that-format-only-an-with-formatdate-creating-column-i-am-getting-that-as-string-datatype-i-need-it-as-date-onl-y/45358)
**Author:** [@Kavtya](https://community.amazonquick.com/u/Kavtya)\ **Replies:** 10\ **Last updated:** [May 12, 2025, 2:26pm UTC](https://community.amazonquick.com/t/how-to-convert-date-format-yyyymmddthhmmss-to-yyyymmdd-in-quicksight-i-have-try-using-edit-date-formation-it-is-taking-it-as-buydefault-that-format-only-an-with-formatdate-creating-column-i-am-getting-that-as-string-datatype-i-need-it-as-date-onl-y/45358 "2025-05-12T14:26:22Z")
--- ## [Change date time format](https://community.amazonquick.com/t/change-date-time-format/46001)
**Author:** [@hdezeduardo](https://community.amazonquick.com/u/hdezeduardo)\ **Replies:** 1\ **Last updated:** [May 8, 2025, 3:12pm UTC](https://community.amazonquick.com/t/change-date-time-format/46001 "2025-05-08T15:12:29Z")
Hello, Is there a way for me to change the date time format to apply to all my date fields from MM-DD-YYYY to DD-MM-YYYY? [Next page](https://community.amazonquick.com/tag/date/76.md?match_all_tags=true&page=1&tags%5B%5D=date)