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…

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 , how-to	1	446	March 7, 2023
Calculate Time filter for Business Hours Q&A quick-sight , calculations , how-to	1	237	June 8, 2023
How to conditionally format dates in quicksight matrix Q&A formatting , quick-sight	3	550	November 17, 2022
Brreaking down date format in quicksight using calculated field Q&A quick-sight	4	5711	October 27, 2021
Can I change the column colors based on the value of the column name in a pivot table? Q&A quick-sight , how-to	2	362	June 14, 2023

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

Related topics