[AccessD] Access XP (2002) - unknown function name date()

They are not equivalent.

Date() always return midnight as the time part (i.e. it truncates the current datatime to a 
whole number),  Now() always returns the current time including the decimal part, 

They may look the same in a textbox depending on the formatting, but try doing "equals" 
comparisons on the fields to select for a date and you will have all sorts of problems.

On 1 Dec 2009 at 16:16, Max Wanadoo wrote:

> Could your problem be a  leading space before the now() in the design.  I
> have always put date() in the design and General as type which is equiv of
> now() but never gives this error.
>