WEEK?

[Randy]

I know how to come up with a week's number.

What I need to do is set an unbound field to the first date in week say
24 and another unbound field to the last date in week 24 or for that
matter any week number. Is there a way to do that?

 

[Duane Hookom]

To get the Sunday, try an expression like:
DateAdd("d", -Weekday(DateAdd("ww",24,#1/1/2005#))+1,DateAdd("ww",24,#1/1/2005#))

 

[Randy]

Thanks alot.........................