Decrease Due Date by Formula Tool

[masfouaa]

Hi all, I want to create formula that can change the DUE DATE column.

First, I want to select the nearest 5 days from the column 

-if the nearest one is same as the day of today = keep the date as it is

-if the due date is tomorrow  = change it to today date

-if the due date is after tomorrow or the range between "after two days or three"= change it tomorrow date

-otherwise the remain due dates will keep it as they are

I hope you understand my idea and looking for your help

[mbarone · Accepted solution]

Hi @masfouaa , bring in a formula tool and check out the DateTimeAdd function and the other functions on the DateTime Functions page of the help files.  That will get you what you need.

An example: 

Nearest day = [yourdate]

Nearest day + 1 = DateTimeAdd([yourdate],1,'day')

Nearest day + 2 = DateTimeAdd([yourdate],2,'days')

etc.

[masfouaa]

Hey  mbarone 

thanks a lot for your help and your reply is very helpful. 

[mbarone]

Welcome!