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

     Rate

 

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

Outcomes