Week ending date in group header

  • Thread starter Thread starter sunflower
  • Start date Start date
S

sunflower

I am a newbie, so bear with me...

I have a group header with a text box
="For Week No. " & Format$([DateDue],"ww",0,0)

which gives me "For Week No. 46"

What I really what is "Week Ending 11/11/05"
instead of the week number

Any help is greatly appreciated
 
Set the text box Data Control Source = "Week Ending " & [DateDue]
--
***************************
If the message was helpful to you, click Yes next to Was this post helpful
to you?
If the post answers your question, click Yes next to Did this post answer
the question?
 
Try something like:
="For Week Ending: " & DateAdd("d",7-WeekDay([DateDue]),[DateDue])-1

This assumes your week ending date is a Friday and not Saturday
 
This gives me the date of the first record...
I need it to be every Friday of the week
 
Back
Top