[AccessD] Six Month Review

That's odd because here in the UK DateSerial takes year, month, day! How can
that be?

Also DateSerial and DateAdd give differing results when handling month-end
situations. Add 6 months to the last day of August 2007 and DateAdd gives
the last day of Feb 2008, whereas DateSerial gives 1st March. You'd need to
be aware if that's significant.


--
Andy Lacey
http://www.minstersystems.co.uk




--------- Original Message --------
From: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Six Month Review
Date: 01/02/07 16:41


I doubt it. I like the DateSerial method because if I am building a date, I
don't have to worry abut the format of a date, or international standard.
DateSerial is always month, year, day.

Just a personal quirk, I guess.

Drew

-----Original Message-----
From: Susan Harkins [mailto:ssharkins at setel.com]
Sent: Thursday, February 01, 2007 10:31 AM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Six Month Review

Why? Is it superior to the shorter expression in some way?

Susan H.

My personal preference is the DateSerial function:

DateNxtReview=DateSerial(Month(DateReview)+6,Year(DateReview),
Day(DateReview))


--
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

________________________________________________
Message sent using UebiMiau 2.7.2