Question Locked
0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I would like to create a report on dates that are not indicated in date field ranges. We have a travel service, and I need a report to indicate availability (which exists between the last day of any given reservation, and the first day of the next reservation) of vacation rentals. I am having a hard time figuring out how it is done.
2 replies
by thomasmreagan Accepted solution
Clarifications
by tony hopkinson Accepted solution
but this is the way you should be going
https://www.techrepublic.com.com/5208-6230-0.html?forumID=102&threadID=260882&messageID=2477107
If you had a table called Alldates
Then a simple join like
Select AllDates.Date
From AllDates,Reservations where AllDates.date between Reservations.FirstDate and Reservations.LastDate will give you booked
NotBooked is then simply all those in AllDates and Not in Booked.
HtHs
This discussion is closed to new replies.
Trending Software posts
Sort by Trending
1 helpful
1 reply
Question Unanswered
How Are Teams Testing AI-Generated Code Before Production?
0 helpful
0 replies
0 helpful
5 replies
0 helpful
20 replies
Discussion
Is There any Reverse Video Search Tool
0 helpful
8 replies