Forum Discussion

pakalolo855's avatar
pakalolo855
Copper Contributor
Jan 05, 2022

Need to keep record of previous dates in sharepoint list

Hello all, 

 

I have a list with a few date columns. One is calculated to add a certain number of days from the input date column and the third is validated to say overdue or valid based on a certain number of days. 

 

Status    Due       Lastupdate
OverdueJun-2021Jun-2016

 

I would like to keep record of all prior dates, so when updating Lastupdate column in Sharepoint, is there a way to track all the prior dates entered here? I know versioning is an option but i want a quick list or table that shows all prior update dates in a list or excel sheet format. 

 

I had thought of trying to do some sort of add column when Lastupdate changes to move the previous date to a new column but not sure if that is possible in sharepoint lists. 

 

Any help is appreciated!

No RepliesBe the first to reply