creating weekending date

[nclemmons]

Hello,

Using an event date, I would like to create a week of onset date using the weeks ending every Saturday (ex. EventDate = 01/03/2015, then WeekOnset = 1). I tried to use this code in the control source "=WeekendDate([EventOnset])" but all it does is return a "#Name?" in the WeekOnset field. Can anyone give me any tips?

I tried to follow other posts about weekending date but I'm pretty much a beginner and couldn't get them to work at all.



Thanks!

[pbaldy]

I'm not clear on what you want, but is it here?

Date/Time expressions

[ranman256]

Where is the code for WeekendDate() ?

[nclemmons]

I was able to get it by using: Private Sub EventOnset_Click()
WeekOnset = DatePart("ww", [EventOnset])
End Sub
Private Sub WeekOnset_Click()
WeekOnset = DatePart("ww", [EventOnset])
End Sub

Thanks for responding. I'm looking forward to learning from this forum.

[pbaldy]

Glad you got it working, and welcome to the site!