Kaup, Chester A
kaupca at chevrontexaco.com
Mon Jan 3 15:07:42 CST 2005
I need to return 12 when current month is January. Chester Kaup Information Management Technician IT-MidContinent/MidContinent Business Unit CTN 8-687-7415 Outside 432-687-7415 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Monday, January 03, 2005 3:02 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Month problem On 3 Jan 2005 at 14:52, Kaup, Chester A wrote: > Why does the following function return 0 rather than 12? Is there a > better way to do this? Month(Date())-1 > Month() returns a number between 1 and 12, since you are subtracting 1 from it, it will retun 0 in January. A better way to do what? -- Stuart -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com