Share Point List Last Modified Date

Question

Ok, so I figured out how to add a row which shows the last modified date, excellent! However, when I upload new records into my list it shows the last modified date at the date I added the records. Any way to avoid the initial modified date and only show that date when the record gets modified?

Answer 1

The Modified column is built-in and you can't change it. But, you can create a new column to achieve your goal, like this:

1. Create a Calculated column, named "My modified";
2. Type this formula in the Formula box: =IF([Modified]=[Created],"",Modified)
3. The data type is: Date and time; (you can shoose keep date only or with time)
4. Remove the built-in Modified column from your default view, replace it with the new "My modified" column.