I am trying to use the GETDATE function in Access and keeping getting an operator error. Below is the code i thought would work to give me the day difference between current date and LastStarted column.
SELECT dragon.LastLoginName, dragon.LastStarted, GETDATE() CurrentDateTime, DATEDIFF(day,LastStarted,GETDATE()) As Daydiff
FROM dragon INNER JOIN employeeinfo ON dragon.LastLoginName = employeeinfo.LOGNAME;
I also thought i could just input SELECT GETDATE(); in an access query to get the current date/time, but i also get an error when entering that info.