[AccessD] Dates From Previous Month

Perfect.  Thanks Drew. 

Mark Boyd
I/S Supervisor
McBee Associates, Inc.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
DWUTKA at marlow.com
Sent: Tuesday, June 07, 2005 11:58 AM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Dates From Previous Month

1st Previous month=DateSerial(Year(date),Month(date)-1,1)
Last Previous month=DateSerial(Year(date),month(date),0)

Drew
-----Original Message-----
From: Mark Boyd [mailto:MarkBoyd at mcbeeassociates.com]
Sent: Tuesday, June 07, 2005 10:50 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Dates From Previous Month


I'm looking for a way to get the 1st and last dates from the previous
month.  I'm working on an invoicing app, and need to determine the
previous months date range.  Is there a function, or use of the Format
statement that will give me this info?
 
Thanks,
Mark Boyd
I/S Supervisor
McBee Associates, Inc.
 
-----------------------------------------
This message and any attachments are intended only for the use of the
individual or entity to which it is addressed and may contain
information that is privileged, confidential, and exempt from disclosure
under applicable law. If the reader of this message is not the intended
recipient, or the employee or agent responsible for delivering the
message to the intended recipient, you are hereby notified that any
dissemination, distribution or copying of this communication is strictly
prohibited. If you have received this communication in error, please
notify the sender by replying to this message, and then delete it from
your system.
-------------------------------------------
--
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
 
-----------------------------------------
This message and any attachments are intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential, and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify the sender by replying to this message, and then delete it from your system.
-------------------------------------------