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

Talking about format not  contents.
Read the  posting

Max


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan
Sent: 01 December 2009 16:32
To: Access Developers discussion and problem solving
Subject: Re: [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.
> 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com