Hi All! I am hoping this is an easy problem to solve 🙂
I thought this would be really simple, but I'm struggling.
I have a project "Start Date" field. Every time one of my users updates that "Start Date" I would like AT to automatically retain the last start date before that change in a "Last Start Date" field.
So if "Start Date" was 01/05/2024 and someone changed it to 12/05/2024, then "Start Date" would read 12/05/2024 and "Last Start Date" would read 01/05/2024. Each field would then update every time the "Start Date" field is consequently updated, which can happen numerous times.
Any help / advice would be very much appreciated. I am hoping that this can be done with AT as opposed to using any external connector.......