Skip to main content

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')

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

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

Thank you! 

Reply


Terms & Conditions