I have a sequential list of dates in a schedule. They start from a dd/mm/yyyy in 2016 and continue to a dd/mm/yyyy in 2018. I also have another table that shows when a pickup was made against this schedule. The last pickup date will always be the max pickup date in this table.
I can I use this max pick up date against my schedule table, so that the schedule table only shows dates on or after the max pickup date? (ie as if the max pickup date was row 1?)