I have a table with a date field (dates when file had been backed up). The backing up of files doesn't happen everyday so there will be gaps in the date sequence.
what I need is to write a query to return for every entry (row), the previous back up date.
any idea how this can be done?
what I need is to write a query to return for every entry (row), the previous back up date.
any idea how this can be done?