[AccessD] HOW TO: Determine start and end of week given a specific date

Seth Galitzer sgsax at ksu.edu
Wed Jan 29 16:04:01 CST 2003


Charlotte,

Yes, that does work.  However, I would contend that using DateAdd() is a
"safer" way of doing it, in that if MS ever changes how dates are
stored, presumably DateAdd will still act as expected.  I suppose it's
also a matter of personal style.  Performance-wise, either way should be
fiarly equivalent.  I've never noticed a significant lag when using
DateAdd.

Seth

On Wed, 2003-01-29 at 15:22, Charlotte Foust wrote:
> A simplified version is:
> 
> basGetWeekStart  = dte - WeekDay(dte) + 1
> 
> Charlotte Foust
> 

-- 
Seth Galitzer			sgsax at ksu.edu
Computing Specialist		http://puma.agron.ksu.edu/~sgsax
Dept. of Plant Pathology
Kansas State University




More information about the AccessD mailing list