Creating a new column. IF Date <= 90 days of Column A then [Column A]

[wonka1234]

Hi,

I am trying to create a new column called Max Date.

If [action_date] is less then 90 days of column A then use column A

Elseif [action_date] is less then 90 days of column B then use column B

else ""

endif

The issue here is column A and column B are year and months. Ie Column A is literally 202202, and column B is literally 202203

This is how these columns look:

How can I do 90 days less then these months? or any amount of days for that matter? I dont want to hardcode any values here.

[BS_THE_ANALYST]

If you want to do 90 days less than a date, you can use DateTimeAdd(**insert date here**, -90, "day") 

You can change the -90 to whatever you want. You can also change the 'days' part aswell to months/years. I'll attach the help guide below for specifics.

[BS_THE_ANALYST]

I think this is doing what you want? I've attached the workflow