I'm trying to use a filter to capture only the leases from today to the end of the year. I don't want to use a set starting date because when I look up the information at a later date I want that new date to be the starting date. I don't see how this is possible in the filter function. Any ideas?
Perhaps your could create two parameters. Start Date and end of the fiscal year.
You could then check if your leases are between these two.
[Date] >= [StartDate] and [Date] <= [EndDate]
Then you can use this as a filter and keep only the True.
IF you do not want to use a set starting date substitute TODAY() for the starting date.