Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have dates like below 'Actual dates' and here after the date 17/06/2024 all dates should consider as 17/06/2024 and data mapped after 17/06/2024 should mapped to 17/06/2024. We are creating master calander on Actual dates.
Actual dates | required output |
26/05/2024 | 26/05/2024 |
26/06/2024 | 26/06/2024 |
27/01/2024 | 27/01/2024 |
05/02/2024 | 05/02/2024 |
17/06/2024 | 17/06/2024 |
02/03/2025 | 17/06/2024 |
03/03/2025 | 17/06/2024 |
04/03/2025 | 17/06/2024 |
05/03/2025 | 17/06/2024 |
06/03/2025 | 17/06/2024 |
07/03/2026 | 17/06/2024 |
08/03/2026 | 17/06/2024 |
09/03/2027 | 17/06/2024 |
10/03/2027 | 17/06/2024 |
Thanks..
Store max 2024 date in variable
Then use if condition like if date >variable then variable else date
Store max 2024 date in variable
Then use if condition like if date >variable then variable else date