[AccessD] Dates From Previous Month

I usually chuckle when I see DateAdd all over the place.  I find DateSerial
to be tremendously effective.  One of the more useful purposes is dealing
the 'international' dates.....DateSerial is universally Year, Month,
Day....so there is no need to worry about local settings, if you use it
properly. 

Not trying to bring up the internationally compliant thread... <grin>

Drew

-----Original Message-----
From: Stuart McLachlan [mailto:stuart at lexacorp.com.pg]
Sent: Tuesday, June 07, 2005 5:33 PM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Dates From Previous Month


On 7 Jun 2005 at 11:20, Reuben Cummings wrote:

> Drew, does that mean the 6-0-05 = 5-31-05?
> 
> I learned something today.  Thanks.
> 

As well a 0, try playing around with negative numbers in both the month and 
day parameters of DateSerial

It's often easier than using DateAdd :-)

-- 
Stuart


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