- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 09, 2023 02:24 PM
Hi all! I am back looking for support with a formula to return a date based on a "created" date and a variable.
So far I've been trying to get an IF statements with a DATETIME_FORMAT included to work, but I'm making no progress...
My Goal: Create a column that shows an Estimated Pickup Date which is either 11 days after the created date, or 6 days after the created date if the "rush" checkbox is ticked.
This is what my columns look like:
Any brilliant minds out there who can point me in the right direction?
Thanks in advance!
Devon
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 09, 2023 02:52 PM - edited ‎Nov 10, 2023 01:57 PM
Hey @Spruce
Check out this video here! https://youtu.be/NcxcPD1zuaw
This is the formula I used:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 09, 2023 06:51 PM
I figured it out! Asking the question helped me realize what the solution was!
For anyone else, here's @stevendasilva 's formula with the addition of DATETIME_FORMAT:
DATETIME_FORMAT(IF(Rush,
DATEADD(Created, 6, 'days'),
DATEADD(Created, 11, 'days')),'ll')
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 09, 2023 02:52 PM - edited ‎Nov 10, 2023 01:57 PM
Hey @Spruce
Check out this video here! https://youtu.be/NcxcPD1zuaw
This is the formula I used:
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 09, 2023 06:47 PM
Oh man thank you so much @stevendasilva for the quick reply! Your suggestion is perfect. The only other thing I'd ask, if you have the time, is if there's a way to format the output without the time and in a "friendly date" format (i.e. Nov 9, 2023), or if I have to create an additional column to convert the date format?
Thank you so much!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 09, 2023 06:51 PM
I figured it out! Asking the question helped me realize what the solution was!
For anyone else, here's @stevendasilva 's formula with the addition of DATETIME_FORMAT:
DATETIME_FORMAT(IF(Rush,
DATEADD(Created, 6, 'days'),
DATEADD(Created, 11, 'days')),'ll')
