How to get five year back date

[swethav]

I want five years back date for date column yyyymmdd .

Like if I have date as 20230618 I want it as 20180618

[atcodedog05 · Accepted solution]

Hi @swethav 

Here is a workflow for the task.

Formula: change [field1] to column name

DateTimeFormat(DateTimeAdd(DateTimeParse([Field1],"%Y%m%d"),-5,"years"),"%Y%m%d")

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[swethav]

Thank you . I got it 

[atcodedog05]

Happy to help 🙂 @swethav 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any other issues 🙂