Drew Wutka
DWUTKA at marlow.com
Thu Feb 1 10:57:55 CST 2007
It is Year, Month, Day..... sorry, still working on first cup of coffee, and Outlook still doesn't use Intellisense!!! ;) Good point on the differences. Drew -----Original Message----- From: Andy Lacey [mailto:andy at minstersystems.co.uk] Sent: Thursday, February 01, 2007 10:52 AM To: Access Developers discussion and problem solving Subject: Re: [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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com