Forum Discussion
Seemingly simple date issue...
My company rents band & orchestra instruments to school children. I have a handful of data query tables and I've created a calendar table. For this issue, I think all I need to focus on are thes...
As time passes, I simply want to see what the current rentals count is over time. Here's an image of something I worked up quickly.
Let me know if you have any questions. If it helps you think through things, these are long term rentals that people rent toward ownership, not instruments that are rented for a few days and brought right back.
Of course, no sooner than I post, then I see a slight mistake in my data. There is a single instrument that has been paid off (Primary Key #8), reducing the total number of current rentals by one. The problem is, I don't see anywhere in the data provided by our PoS software that gives a payoff date, so I'm not sure how or when that would get calculated. This could be a problem... ugh