The last time I used Access I remember that dates needed to have '#' put around them to parse, while SQL Server can just use single quotes. Is this still the case? What about Oracle?

DATEDIFF is a common function in the SQL Server to find the number of days between two dates. Oracle offers its own solution, although does not have the DATEDIFF function.