all future dates mapped to one date

[Krish2459_58]

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..

[anat · Accepted solution]

Store max 2024 date in variable

Then use if condition like if date >variable then variable else date