Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Re: Formulas for dates

Solved
Jump to Solution
288 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Austin-Scheib
4 - Data Explorer
4 - Data Explorer

I am trying to track when i should expect a project back based on the amount of days given to return. The first return length is 70 days or 10 weeks. The second time it is submitted is 30 days return. 

Column: Submitted date: (constant)- user entered 

Columns: Expected Project Return (date) 

DATEADD({SUBMITTED Date }, 10, 'week')) 
This checks out good. 
 
when I have a Resubmittal column(date) I would like the Expected Project Return Date to now show 
DATEADD({SUBMITTED }, 30, 'day')) 
So in short i want the expected return date column to update once the resubmittal date is updated. 
1 Solution

Accepted Solutions
bcrossley
6 - Interface Innovator
6 - Interface Innovator

Calculating dates is always fun. 

In order to accomplish what you're looking for you'll need a conditional statement.

Something like:

 

 

IF(
  {Resubmittal},
  DATEADD({SUBMITTED}, 30, 'day'),
  DATEADD({SUBMITTED}, 10, 'week')
)

 

 

Hope this helps!

See Solution in Thread

4 Replies 4
bcrossley
6 - Interface Innovator
6 - Interface Innovator

Calculating dates is always fun. 

In order to accomplish what you're looking for you'll need a conditional statement.

Something like:

 

 

IF(
  {Resubmittal},
  DATEADD({SUBMITTED}, 30, 'day'),
  DATEADD({SUBMITTED}, 10, 'week')
)

 

 

Hope this helps!

Alexey_Gusev
13 - Mars
13 - Mars

Hi,
I would use the formula provided by @bcrossley  , as better readable.
Just want to show you can transform formulas  in a different ways, like put the condition exactly where you need to change the value:

DATEADD({SUBMITTED Date}, IF(Resubmittal,30,70) ,'days')

 

Thank you for your help in resolving this. 

 

Thank you for the response the line worked.