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

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 😀👍

date.yxmd