August 17, 200421 yr 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
August 17, 200421 yr 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.
Create an account or sign in to comment