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 ?

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

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.