My understanding is:
The
date/Date can be changed, hence I assume its usage as 'Date Added' is by convention, I use it to hold the timestamp of when I last did something to the book - Add to library being the first something
The
date_last_modified/Modified cannot be changed. It has a fixed usage - the date calibre last did something to the database for the book.
BR