return first day of the week from weeknumber

[Barb]

Hi Everyone
How can I get FirstDayOfWeek (being Sunday) From a WeekNumber.
I'm calculating Hours worked per week and displaying it on a form.
It's a datasheet view that displays :Name, WeekNumber, PaidHours,
NonPaidHours.
Instead of WeekNumber ie. 15, 16, 19 I'd like to show "Week of " and a
Sunday of that week. or even better Start of the week date and End of the
week date. - so I could do "Dates between StartOfTheWeek and EndOfTheWeek"

Please help
thanks
Barb

 

[KARL DEWEY]

Use the field that used to derive the WeekNumber and bring it along with the
WeekNumber.
Then use the function -- [YourDateField]-Format([YourDateField],"w")+1

This determines the day of the week, substracts that from the date and adds
one.

 

[Barb]

Hi Karl
Thanks for the reply, but I can't do that.
Underlying query is grouping data based on a WeekNumber, so the dates
themself are no longer visible. All I get is a person name, weeknumber and
how many hours they worked or not.

Barb

Use the field that used to derive the WeekNumber and bring it along with the
WeekNumber.
Then use the function -- [YourDateField]-Format([YourDateField],"w")+1

This determines the day of the week, substracts that from the date and adds
one.
--
KARL DEWEY
Build a little - Test a little

Hi Everyone
How can I get FirstDayOfWeek (being Sunday) From a WeekNumber.
I'm calculating Hours worked per week and displaying it on a form.
It's a datasheet view that displays :Name, WeekNumber, PaidHours,
NonPaidHours.
Instead of WeekNumber ie. 15, 16, 19 I'd like to show "Week of " and a
Sunday of that week. or even better Start of the week date and End of the
week date. - so I could do "Dates between StartOfTheWeek and EndOfTheWeek"

Please help
thanks
Barb

 

[Barb]

Hi Karl

Got it, got it, got it.
thank you,thank you,thank you,thank you,
You've made my day

Barb

Use the field that used to derive the WeekNumber and bring it along with the
WeekNumber.
Then use the function -- [YourDateField]-Format([YourDateField],"w")+1

This determines the day of the week, substracts that from the date and adds
one.
--
KARL DEWEY
Build a little - Test a little

Hi Everyone
How can I get FirstDayOfWeek (being Sunday) From a WeekNumber.
I'm calculating Hours worked per week and displaying it on a form.
It's a datasheet view that displays :Name, WeekNumber, PaidHours,
NonPaidHours.
Instead of WeekNumber ie. 15, 16, 19 I'd like to show "Week of " and a
Sunday of that week. or even better Start of the week date and End of the
week date. - so I could do "Dates between StartOfTheWeek and EndOfTheWeek"

Please help
thanks
Barb