REPLACING THE YEAR IN DATE COLUMN

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

4/29/2030

3/10/2020

Can you help me this one pls?

Input

Common Use Cases

Best Practices

Accepted answers

Qiu

@dunkindonut7777

@AngelosPachis Thank you for pointing out. Sorry.

AngelosPachis

Hi @dunkindonut7777

If your field has a date data type, then the formula provided won't work. You would have to use embedded Datetime Functions within Alteryx to get the answer right.

For example, you can do something like this

Which will subtract 10 years if the year of the effective date is 2030.

Hope that helps.

Angelos

All comments

Qiu

@dunkindonut7777
Something like this should help./

AngelosPachis

Hi @dunkindonut7777 ,

Similar to @Qiu solution, but I did not replace the "/" before the year so it keeps the mm/dd/yyyy format.

Also if you then want to convert the field to a date field, then that should have a "yyyy-mm-dd" format. You can convert it within the formula tool with the Datetimeparse function.

Hope that helps,

Cheers

Angelos

grazitti_sapna

Hi @dunkindonut7777 , My solution is somewhat similar to @AngelosPachis but using a different function. Please refer to the screenshot and workflow attached.