[AccessD] Month problem

How about:

Format(DateAdd("m",-1,Now()),"mm")

HTH
David McAfee

-----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 12:52 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] Month problem


Why does the following function return 0 rather than 12? Is there a
better way to do this?
Month(Date())-1

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. 



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