backup get date

use msdb
select bmf.media_set_id,bmf.physical_device_name ,bset.database_name,bset.backup_finish_date,bset.type from backupmediafamily bmf
inner join backupset bset
on bmf.media_set_id=bset.media_set_id
where bset.backup_finish_date>'2010-05-10' and bset.type='d'