AnsweredAssumed Answered

Getting a date from the next record

Question asked by user28271 on Nov 24, 2018
Latest reply on Nov 24, 2018 by dsvail

I have a table of staff rates.


The two primary fields are:

     Start Date



I need to add an End Date, but I want it to be automatically loaded based on the Start date of the next record.


So when a user start a new rate record it will post the start date (less one) as the end date of the previous record.


Any recommendations