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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display the Date not Week Number 1
Group Week Sunday to Saturday 5
week (WW) conversion to date in Access Graph 2
Specific Date Headers 3
Per Week Format 3
Get date for start of week 3
Grouping by date - How To: Show the first day of the week instead of the first date entered in that 2
Date Format In A Report 2

Top