I currently have a Database using the DateDiff function. On 02/28/02 this worked fine and has worked fine since December of last year. Now it does not work and I get an error message of

This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. (Error 3071)


Days Since Entry: DateDiffW([Entry Date],Date())

I need help to fix this!!

Look up the DateDiff() function in help for the correct syntax. You have it wrong, at least in your question.

The DateDiffW is a valid function. It is created as a user defined function in a module and allows me to see the numbers of days in a the work week between to given dates.

In which case post the code so that we can see where it is going wrong.

I am guessing that a) you have checked the data is a valid date and b) that your regional settings haven't changed to show your date as dd/mm/yy