Date Range_color code

[nvijay5757]

Hi 

date range for color code

sample data:

study	start_date	end_date	date_range	blue	grey	original	new	tracking
M6944	2021-08-03			2021-09-27	2021-10-15 00:00:00	2022-10-14 00:00:00	2023-06-26 00:00:00	Y
M6944	2021-08-03			2021-08-24	2021-08-21 00:00:00	2022-07-23 00:00:00	2022-04-09 00:00:00	Y
M6944	2021-08-03				2022-01-15 00:00:00	2022-04-09 00:00:00	2022-04-09 00:00:00	N
	end_date=max(original,new)

1. if original > new then from original to new display pink color, if original <new then display green.

2. if tracking=y from blue color date to end date display blue color

please help me for the expression.

i have generated dates.