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

Heenan, Lambert Lambert.Heenan at chartisinsurance.com
Tue Dec 1 11:47:01 CST 2009


You state " I have always put date() in the design and General as type which is equiv of now()" 

Critique:
	"General" is not a data type. It is  a format specification.
	The General format is not the equivalent of the function Now()
	You do not use the word "format" anywhere in your first post.
	Date() is not equiv [sic] of Now()

Please include <psychic powers> tags in future posts which do not talk about what you intend to talk about. :-)

Next discussion?

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Max Wanadoo
Sent: Tuesday, December 01, 2009 11:56 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access XP (2002) - unknown function name date()

NOT on MY posting which is what I was referring to.

End of discussion

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:52
To: Access Developers discussion and problem solving
Subject: Re: [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


-- 
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




More information about the AccessD mailing list