Hi I would like to ask about regarding the date column of my data. I I have here series of dates that has 2020 and 2030 year, I would like to replace the 2030 into 2020 same as the other fields.
EffectiveDate |
3/30/2030 |
3/30/2030 |
4/29/2030 |
4/29/2030 |
3/10/2020 |
3/10/2020 |
Can you help me this one pls?
Solved! Go to Solution.
i've encounter that i would like to change only the year part, so we can use the replace function in the formula tool:
below are the code:
if Left([date_action_up], 4) != '2023' then Replace([date_action_up],Left([date_action_up], 4), '2023')
else [date_action_up]
endif
some screenshot for easy referral.
cheers!