Replace only the year in Date Column using a condition

Please help with an easy way to replace only the year of the date based on condition

* if the year in the date is greater than 2032 then change it to 2032

it should look like this.

Appreciate your help. Thanks

Date Time

Accepted answers

IF tonumber(right([Field1],2))>32
THEN REGEX_Replace([Field1], "(\d{1,2}/\d{1,2}/\d{2})(\d{2})", "$1")+"32"
ELSE [Field1]
ENDIF

Many thanks

Shanker V

@Mahesh6279 One way of doing this

One way of doing this.

Many thanks

Shanker V

IF tonumber(right([Field1],2))>32
THEN REGEX_Replace([Field1], "(\d{1,2}/\d{1,2}/\d{2})(\d{2})", "$1")+"32"
ELSE [Field1]
ENDIF

Many thanks

Shanker V