[AccessD] First/last day of week

FirstDayOfWeek = datDateToCheck - (Weekday(datDateToCheck )-1)
LastDayOfWeek = datDateToCheck  + (7-(Weekday(datDateToCheck ))

--
John V. Ruff – The Eternal Optimist :-) 

“Commit to the Lord whatever you do, 
and your plans will succeed.” Proverbs 16:3

-------------- Original message -------------- 
From: "John Colby" <jwcolby at ColbyConsulting.com> 

> Does anyone have these functions? 
> 
> John W. Colby 
> www.ColbyConsulting.com 
> 
> 
> -- 
> AccessD mailing list 
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd 
> Website: http://www.databaseadvisors.com