GETDATE()

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.
jsawickiAsked:
Who is Participating?
 
pteranodon72Connect With a Mentor Commented:
The DATEDIFF function is different in Access as well. The first parameter is a string: "d" for days, "m" for months, "yyyy" for years -- check Access help on DateDiff -- the parameters can be misleading.

SELECT dragon.LastLoginName, dragon.LastStarted, Now() As Today, DATEDIFF("d",LastStarted, Now()) As LastUsed FROM dragon INNER JOIN employeeinfo ON dragon.LastLoginName = employeeinfo.LOGNAME;

HTH,
pT72
0
 
IrogSintaCommented:
To get the current date, use DATE().
To get the current date & time, use NOW()
0
 
Rey Obrero (Capricorn1)Commented:
<no Points Please.>

GetDate() is an SQL function,
In Access use the functions posted by IrogSinta..  ( kumusta kabayan ?)
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
IrogSintaCommented:
@capricorn1: (Mabuti naman. Ang galing mo pala dito sa EE.)  I'm impressed!
0
 
Rey Obrero (Capricorn1)Commented:
<@IrogSinta: email me, see my profile for the addy>
0
 
jsawickiAuthor Commented:
The change worked, but now everytime i launch the code, it prompts me to enter a date versus performing the calculation automatically.  Why is that and what do i need to do so it just autopopulates.
0
 
jsawickiAuthor Commented:
Also, when i do enter a date, i get an error in the new column so there is something wrong with my code.
0
 
IrogSintaCommented:
Could you post your SQL statement so that we could see what's going on?
0
 
jsawickiAuthor Commented:
SELECT dragon.LastLoginName, dragon.LastStarted, Now() AS Today, DateDiff([day],[LastStarted],Now()) AS LastUsed
FROM dragon INNER JOIN employeeinfo ON dragon.LastLoginName = employeeinfo.LOGNAME;
0
 
IrogSintaConnect With a Mentor Commented:
Your DateDiff function needs to be DateDiff("d", [LastStarted], Now()) to get the difference in number of days.
0
 
jsawickiAuthor Commented:
Thanks all and the explanation on the difference between Access and SQL.  I am learning from a SQL book, but have an older Access book that didn't discuss this function, but good to know the help shows this info.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.