Need to create a history of future bookings

[Timmkatt]

CR10
I need to create a report to compare future reservations from a specific date, For example a report where I can see all reservations with a pick up date greater than current date for 30, 60 or 90 days out but I want to see the same historical information from a year ago so I can compare what I had out in the future then compared to now. Is there a formula to deduct X months from the current date or something similar? Thank you for any help you can provide.

 

[lbass]

Try a record selection formula like this:

{table.pudate} in currentdate to currentdate+90 or{table.pudate} in dateadd("yyyy",-1, currentdate) to
dateadd("yyyy",-1, currentdate)+90

You can then breakout the dates based on the years and the number of days out using similar formulas.

-LB