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.