Date Range from week number

[QuietRiot]

I've tried a bunch of different things on here, but nothing is working for me.

Right now I'm using DatePart("WW", Date(),0) to get the week number.

How can I get the date range to show on my report. This is week 29. So it should show today (which is a sunday) 7/13/2008 - 7/19/2008

thanks,
QR

 

[RuralGuy]

You should find this link helpful.

 

[QuietRiot]

You should find this link helpful.

Thanks but I'm still confused.

 

[RuralGuy]

That link shows how to calculate the date of specific days of the week from a date. What part is confusing you?

 

[QuietRiot]

Alright I got it. I guess I was expecting a simple formula to put in the control source.

I wrote some code on Report Activate to fill in a textbox instead from the link supplied. Seems to work today..

Private Sub Report_Activate()
Dim date1 as String, date2 As String
date1 = Date - Weekday(Date, VbSunday) + 1
date2 = Date + (7 - Weekday(Date, VbSaturday)) + 1
Me.Text12.Value = date1 & " - " & date2
End Sub

 

[RuralGuy]

That looks like it should work.

 

[TechNat]

Between Date() And DateAdd("d",-43,Date())

You can use this in the expression.

Basicly, this expression shows records from today to 42 days previous.

 

[namliam]

To calculate the "Start of the Week" for any old weeknumber for any year please refer here:
http://www.access-programmers.co.uk/forums/showthread.php?t=148093

 

[Vigilante001]

Hi QuietRiot:

I was also in your situation, and I solved it via table-stored ranges. Check out the following post for more:

http://www.access-programmers.co.uk/forums/showthread.php?p=810049#post810049

Hope it helps...