Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Formula between dates

Topic Labels: Formulas
Solved
Jump to Solution
948 2
cancel
Showing results for 
Search instead for 
Did you mean: 
jamiemburns
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello - 

I have a date column of when an event will occur (Showcase Date) & I am wanting a formula to populate deadlines based on number of days before or after this date. Here is the formula I created but it is not working. Any suggestions? 

I have tried: 

DATETIME_FORMAT(DATEADD({Showcase Date},{Number of days},'days),'MM/DD/YY')
1 Solution

Accepted Solutions
jamiemburns
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you! 

See Solution in Thread

2 Replies 2

You're missing a ' after "days"; try:

DATETIME_FORMAT(
  DATEADD(
    {Showcase Date},
    {Number of days},
    'days'
  ), 
  'MM/DD/YY'
)
jamiemburns
5 - Automation Enthusiast
5 - Automation Enthusiast

Thank you!