Week ending date in group header

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
 
S

S Panja

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?
 
D

Duane Hookom

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
 
S

sunflower

This gives me the date of the first record...
I need it to be every Friday of the week
 
Top