[AccessD] Month problem

Subtract a month from the current date and evaluate the month of that date instead....

Month(DateAdd("m", -1, Date()))

-Chris Mackin


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Kaup, Chester
A
Sent: Monday, January 03, 2005 2:08 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Month problem


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


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