Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Feb 08, 2023 01:36 PM
I know this is super simple, but I am new to formulas. Here's my problem:
I have volunteers signing up for a rotation and I'm trying to make a view that will capture their hotel needs, which are generally: Check In one day BEFORE their First Day BOG and Check Out one day AFTER their Last Day BOG (BOG = Boots on the Ground).
This is the formula I am using to get their Check In date: DATEADD({First Day BOG},-1,'days')
It is not calculating correctly.
This is the formula I am using to get their Check Out date: DATEADD({Last Day BOG},1,'days')
Also not calculating correctly.
Help & TIA
Solved! Go to Solution.
Feb 08, 2023 02:25 PM
Hi Lisa,
Here's the formulas you want:
Feb 08, 2023 02:25 PM
Hi Lisa,
Here's the formulas you want:
Feb 08, 2023 02:42 PM
It worked! Not sure why I needed the DATETIME_FORMAT - it was actually formatted fine - but I'm happy with the results. Thank you!