Getting SQL Server Last Restore history Date.

SELECT RESTORE_HISTORY_ID,RESTORE_DATE,DESTINATION_DATABASE_NAME,USER_NAME
FROM MSDB..RestoreHistory WITH (nolock)
WHERE DESTINATION_DATABASE_NAME = 'YourDBName'
ORDER BY RESTORE_DATE DESC;