At some point 'Positions' went from listing active positions only to listing all positions, i.e. now including closed positions and future positions.
Despite the 'As-of-date' functionality in the form, it has no effect.
It seems not to be possible to setup an advanced filter that will give you a list of active positions only. The retirement date is not available when you join to the positions duration table.
In Talent you've added a menu item for 'Active positions'. Please do so in F&O as well.