Mark record as current or history

[datakeeper]

I currently have a table of dates and if an entry is > a certain date, I want a calculation field named Status to be set to

[-Queue-]

I think you could add a field to lookup the related CurrentYrStartDate, and then base your calculation on that field instead. It will require a script to relookup the data whenever they change the related field, so you'll need to account for that.