Good morning, I’m developing an appointment booking app and I want the professionals to have 1 month in advance calendar with the timetable of their availability. At the same time the users should have the chance to book within these constraints. How can i set the rolling calendar up? Namely, how…

Taking the constraints and availability out of the question, we will discuss about this first: [image] Pietro_Castellani: Namely, how do I set up a 1 month from now table with rolling dates where each row is “today +1” until row 30? They should then be dates as I want to know the day of the wee…

[image] ThinhDinh: N-HOUR(N)/24-MINUTE(N)/24/60-SECOND(N)/24/60/60+I+1 What’s that “I” do in that formula? Is that a typo? [image] ThinhDinh: This will give you a rolling count of “today + 1” at exactly 12AM. Not quite exactly, right? Because it doesn’t remove the milliseconds compone…

That I is the index, so you got today plus index plus 1 and so on. Is there a way to remove the milliseconds as well?

[image] ThinhDinh: That I is the index, so you got today plus index plus 1 and so on. ah right, sorry I missed that :man_facepalming: [image] ThinhDinh: Is there a way to remove the milliseconds as well? Not that I’m aware of. @Jeff_Hager once suggested that it might be possible, but …

I think this was the best solution I had come up with. [image] Today and 14 days ahead Ask for Help Yes, that is definitely true, and Trunc(Now) is essentially the date at midnight, but the result for today is 44966 which can be converted back to a normal date in Google, …

@Pietro_Castellaniand @Darren_Murphy @ThinhDinh Hey guys! how did you get this to work as a rolling calendar for booking appointments? Since row nr 1 always will be today, the booking will after midnight come on wrong date. Should I build another table for the bookings?

[image] Jeppeh: Since row nr 1 always will be today, the booking will after midnight come on wrong date. Can you show me how it would be the wrong date after midnight? The helper table only serves as a temporary store to calculate the days dynamically. You should write the days to the booking…

Rolling Calendar Availability

Ask for Help

Jeff_Hager June 5, 2023, 4:25am 7

I think this was the best solution I had come up with.

Topic		Replies	Views
Fun with Dates Project Showcase	156	6943	April 19, 2022
Booking slot Calendar Ask for Help	27	3318	June 3, 2021
Customer to input a date to generate a list relative dates Ask for Help	33	2140	February 23, 2021
Find the last day of the following month Ask for Help holdmybeer	47	3292	January 17, 2024
Accounting view: show monthly hours, travel and absences per employee (1–31) using Calendar_layout Ask for Help	10	69	February 10, 2026

Rolling Calendar Availability

Related topics