Help

Re: Formula between dates

Solved
Jump to Solution
257 0
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!