DateAdd?

[Newbie]

Hi,

I have a report that is always run (99%) for a date range starting the on
the Sunday for the previous week.

Is it possible to default my date controls to this period.

for eg
I am running report on ANY date of the week beginning Sept 7th for the
period Aug 31 to Sep 6th

Therefore I would want cbxDateFrom = 31/8/2003 and cbxDateTo = 6/9/2003

Is this possible? and how?

Thanks

 

[Newbie]

Great - works a treat
Thanks
Al

experiment with this...

Debug.Print DateAdd("ww", -1, Date - WeekDay(Date) + 1)
Debug.Print DateAdd("ww", 0, Date - WeekDay(Date))

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com

 

[peter walker]

experiment with this...

Debug.Print DateAdd("ww", -1, Date - WeekDay(Date) + 1)
Debug.Print DateAdd("ww", 0, Date - WeekDay(Date))

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com