I'm looking for some ideas on what the best way would be for me to identify missing load dates from a database we have.
Essentially we load data to a MYSQL database and there is a field marked with the date that it was loaded, called what else, 'loaddate'.
I want to be able to identify if a 'loaddate' has been missed. I would assume this will involve comparing the actual calendar to the first 'loaddate' in the DB and the last 'loaddate' in the DB and finding any missing dates in between those to dates...
Any ideas would be appreciated.