Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 12, 2024 10:09 AM
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')
Solved! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 15, 2024 06:23 AM
2 Replies 2
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 13, 2024 05:38 AM
You're missing a ' after "days"; try:
DATETIME_FORMAT(
DATEADD(
{Showcase Date},
{Number of days},
'days'
),
'MM/DD/YY'
)
Reply
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Apr 15, 2024 06:23 AM
Thank you!
