Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2024 01:47 PM
Hi! I'm trying to set up a formula for a "Production Slack Reminder" that would be based on the "Send Date."
If the "Send Date" falls on a Tuesday, Wednesday, Thursday, or Friday, the "Production Slack Reminder" should happen the day before the "Send Date"
If the "Send Date" falls on a Monday, Saturday, or Sunday, the "Production Slack Reminder" should happen the Friday before that weekend
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 27, 2024 06:33 PM
Try this:
 
SWITCH(
DATETIME_FORMAT(
{Send Date},
'ddd'
),
'Sat', DATEADD({Send Date}, -1, 'days'),
'Sun', DATEADD({Send Date}, -2, 'days'),
'Mon', DATEADD({Send Date}, -3, 'days'),
'Tue', DATEADD({Send Date}, -1, 'days'),
'Wed', DATEADD({Send Date}, -1, 'days'),
'Thu', DATEADD({Send Date}, -1, 'days'),
'Fri', DATEADD({Send Date}, -1, 'days')
)
