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

Original question:

"I am seeing an issue in a linked table where the default value is set to
date()." 

That's contents, not format :-)


-- 
Stuart

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

> 
> 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
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com