I have a query like I want to put a conditional formatting in a date field with time format like if the Job Start Date is 13-Jan-2023 06:13:32 AM then I want the time format condition like if the Job Start Date is less than or equals to 06:00 AM then Green if it is greater than 06:00 AM and equals …

Hello @Biswajit_1993 , posting here the same response as in the other topic for coherence. to use the extract function on the date you have to get just the hour ‘HH’ portion of it then use conditional formatting for the coloring. Create a calculated field (hour) using extract to get the ho…

Are you doing this in SQL or quicksight? You can use extract to get the value of the hour in quicksight and SQL. Extract - Amazon QuickSight Use the extract function for calculated fields in Amazon QuickSight. ifelse(extract(‘HH’,{date_field})=7,‘Amber’,ex…

Hi @Max I am doing it in Quick Sight.

No, but you can add 12 to it. 7pm = 7am +12.

Hi @Max I am not able to achieve my result something gap in my formula. My requirement is if the Date is like 07-Mar-2023 07:00:00 AM — Then color is ‘Amber’ if the Date is like 07-Mar-2023 06:00:00 to 07-Mar-2023 06:59:00 – Then ‘Green’ if the Date is greater than 07:00:00 then ‘Red’

Thanks @EnriqueS for your solutions but in my datasets the date format is 12 hrs date format and the date is like AM & PM please find below some example then in this solution what will be my conditions because 7 AM I can take as ‘Amber’ color but 7 PM should be ‘Red’ but it is showing ‘Amber’ Mar …

How to put the conditional formatting for a date field in time format?

Q&A

Biswajit_1993 March 6, 2023, 6:29pm 4

Hi @Max can we put the condition as AM & PM for Date Time

Need to add conditional formatting on the basics of Time like HH

Topic		Replies	Views
Need to add conditional formatting on the basics of Time like HH Q&A analysis , quick-sight , calculations	1	454	March 7, 2023
Format datetime field in 'dd-MMM-yyyy hh:mm:ss a' Q&A formatting , quick-sight , calculations , Business-Intelligence-Engineer	9	168	July 16, 2025
Calculate Time filter for Business Hours Q&A quick-sight , calculations	1	258	June 8, 2023
Can I change the column colors based on the value of the column name in a pivot table? Q&A quick-sight	2	421	June 14, 2023
Table Visual Conditional formatting Q&A developer , error , quick-sight	8	76	December 12, 2024

How to put the conditional formatting for a date field in time format?

Related topics