Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Oct 22, 2021 08:45 PM
I need help with a conditional statement working with dates.
So in the table there is a time slot however the conditions lie on the right where the start and end times actually are. So if a slot is taken at 10:30 for instance how would I formulate a statement saying if appointment time is between then “booked”
Oct 25, 2021 12:34 AM
Hi @Chafen_Suttle,
Would you like to try:
IF(DATETIME_DIFF({start time},{end time},‘hours’)<DATETIME_DIFF({start time},date, ‘hours’),“No”, “between booked”)
Please text us back if it work finally.
Thanks
Dimitris Goudis
Oct 26, 2021 08:00 AM
Hi Dimitris,
Thanks for your help. I tried it and I’m getting an error message. I tried to add a checkbox instead of a multi select as well but nothing.
https://airtable.com/shrPu54uRS75dttjZ
Maybe that will help make more sense to actually see it. Basically whatever appointment slot is selected an automation will mark extra time off before and after based on the other two fields so anything between them we need to change to not available or checked or something.
Oct 27, 2021 01:47 AM
Hi there,
Please, put all your date fields in the same time zone, then check the results :winking_face: