Please help understand date ranges

Hi all!

I am building a booking app and have 2 small questions regarding specifying dates. I have a start and end date for bookings in my booking data type, and I want to tell the app to run a backend workflow when the booking end date has passed, but not more than 7 days. I am a bit confused as to how to write the equation. Second question is, as far as I understand, bubble’s date times automatically pinpoint 00:00, how can I change that? Thank you so much!

I think, you would do a backend if thing changes, if thing current date is thing nows end time +7 days…, then do workflow.

Or you could just schedule a backend workflow api that does what you need it to do current date +7 days when creating the appointment and have some kind of completed yes/no data field. Another backend that says when appointment nows completed is yes cancel scheduled 7 day work flow. You would have to capture the scheduled workflows id when you schedule it as a data field in your appoinement.