Access Date() function syntax for SQL Server?

[trueharted]

I have an Access database that has a SQL Server backend. A form within Access is pointing to the following query within Access:

SELECT *
FROM dbo_tblTimesheetDetail
WHERE (((dbo_tblTimesheetDetail.DateIn)=Date() Or (dbo_tblTimesheetDetail.DateIn) Is Null));

This works fine on my Windows 2000 with Office XP computer. However, on other computers, one of which is a Windows 98 with Office 2000, it gets an error saying "Undefined function 'Date' in expression." Any suggestions?

 

[ClaireHCM]

How is date() doing in this query?Does it show the system time?Or some other functionality?

 

[TheFrog]

griks,

your problem is simple.

the problem is typical.Not in your syntax or sql but in your references in VBA. Please verify your references library when worked in Access 2000.