[MS_AccessPros] Problem with dates in queries

 

I have a calculated field in a query which works fine for all my users that have runtime 12.0.6612.1000.
But for all my users that have runtime version 12.0.6425.1000 it fails with the error:
"3075 (Function is not available in expressions in query expression)"

The field value in the query is:
"ActiveContract: IIf([ContractStartDate]<Date() And Not [ContractEndDate]<Date(),True,False)"

So, question, am I using the correct syntax in that field?

We are all in the UK but as far as I can tell, all machines are set up with the same regional settings regarding dates.

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 7

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___