Determine the number of days between two dates using the DateDiff function. Find out which customers had a rented movie out for more than a week.
Grab my demo database at: http://www.ralphphillips.com/youtube/Best-Worst-Video-Rental-Database.zip
The YouTube video at /watch/ID4ivBEN_zlNi demonstrates using the DateDiff function to determine hours between a start time and end time.