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

MyWorkFlow.PNG

Workflow

Date Time

Accepted answers

mbarone

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.

All comments

mbarone

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!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335