How would I change the time zone in the filter by date marked as current date, since when filtering by “This day” it shows the next day after 6pm in Mexico time. Thank you so much for the help.

Currently the relative date filters operate on UTC timezone. You would need to create a calculated field that takes the timezone offset into consideration and checks for the current day. ifelse( truncDate('DD', addDateTime(6, 'HH', {dateField})) = truncDate('DD', now()), 'TODAY', NULL ) and …

Thanks for answering. Yes, many tell me to add a calculated field, however my dates in the SPICE and the now() from the dataset are correct, the problem is the Quick Sight date filter component, those options already come by default and not them. I can change, it marks another time zone and not the…

Change timezone in filter by date (marked as "This day")

Q&A

lillie March 3, 2022, 4:53pm 4

This is a repeat of this question: How to change the date and time according to the country for the configuration in Quicksight? - #6 by Naveed. Going to close in favor of that question

Topic		Replies	Views
How to change the date and time according to the country for the configuration in Quicksight? Q&A personalization , feature-request , quick-sight	23	3941	January 26, 2024
Is it possible to change the time zone in the Quick Sight settings for the ready-made date components? Q&A filters , quick-sight	1	533	March 3, 2022
Change Quick Sight's own time zone Q&A filters , quick-sight	4	1409	March 3, 2022
Problems with timezone in dashboards Q&A filters , error , date , quick-sight , Business-Intelligence-Engineer	12	553	December 8, 2023
Quicksight Relative Date filters Q&A filters , quick-sight	1	1011	April 18, 2022

Change timezone in filter by date (marked as "This day")

Related topics