Below is some sample ddl and data. Each row represents an item that is on rent between a period of time. If I run the query as of now it gives me all the rentals in there current state as of today ,I want to be able to see what rentals were actually active/on rent on a particular day in the past e.g yesterday, 2 days ago, 3 days ago etc. I am finding it difficult to do this as I am looking at the data as of today, the rental could be closed(off-rent) today but active yesterday, How do I capture historical data? There is more columns in the table, I posted the below as I thought date columns would be most relevant, All ideas are welcome and any help is greatly appreciated.