topic Re: Replace only the year in Date Column using a condition in Alteryx Designer Desktop Discussions

Replace only the year in Date Column using a condition

Mahesh6279 — Mon, 19 Jun 2023 06:49:23 GMT

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

binu_acs — Mon, 19 Jun 2023 07:00:38 GMT

@Mahesh6279 One way of doing this

Hamder83 — Mon, 19 Jun 2023 07:08:36 GMT

ShankerV — Mon, 19 Jun 2023 07:08:41 GMT

One way of doing this.

Many thanks

Shanker V

ShankerV — Mon, 19 Jun 2023 07:09:38 GMT

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 — Mon, 19 Jun 2023 08:48:26 GMT

can you please modify the code for this date format " 2037-12-31"

Hamder83 — Mon, 19 Jun 2023 10:43:00 GMT

IF
ToNumber(left([PRICING_VALID_END_DT], 4)) > 2032
THEN
"2032"+substring([PRICING_VALID_END_DT],4,10)

ELSE
[PRICING_VALID_END_DT]
ENDIF