return first day of the week from weeknumber

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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

KARL DEWEY said:
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


Barb said:
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
Click to expand...
Click to expand...
 
Hi Karl

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

Barb

KARL DEWEY said:
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


Barb said:
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
Click to expand...
Click to expand...
 
Back
Top