DateDiff function - It doesn't work in some version of acces ?

[bugsy]

Hi All

I've created a database where a query who'se result is loaded on a form uses following function --

DateDiff('d',Date(),[Target Date])-(DateDiff('ww',Date(),[Target Date])*2)-(Select Count(*) from [tblHolidays] where [HolidayDate] between Date() and [Target Date])

I've notice that 2 ppl get an error message when they try to open database, with thatt function coming on an error message
Does this mean they have older access version ?
How can I tell ? Any advise on what to do ?

 

[Brianwarnock]

The Access version is shown in About Microsoft Access in the Help menu.

Why did you not post the error message?

I notice that you put ' not " round the interval string, I know it works in 2002 but maybe not all versions, but as I say the error message might be useful for those who can help.

Brian

 

[bugsy]

The Access version is shown in About Microsoft Access in the Help menu.

Why did you not post the error message?

I notice that you put ' not " round the interval string, I know it works in 2002 but maybe not all versions, but as I say the error message might be useful for those who can help.

Brian

hey Brian
I asked desktop to check Access version of that user; they reinstalled something called "Service Pack3", and it mysteriously worked.

The error messafe simly said - (gave the text of the function) is not recognised.