Max Wanadoo
max.wanadoo at gmail.com
Tue Dec 1 12:12:31 CST 2009
Oops. Yes, see what you mean. I have just Re-read my posting. Guess that probably sounded very rude. Sorry Stuart. Apologies all round. Didn't mean to offend, just posted very quickly. Much to do...little time. Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: 01 December 2009 17:47 To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Access XP (2002) - unknown function name date() 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com