Date Format In A Report

J

Julie Gilliam

I am writng a report to show assessments due on a weekly basis. I created
the report but in the Header of the Report where it will havve the assessment
referencedate group together by the week it is showing up as a number to
represent which week of the year it is. I want it to display the week as a
Sunday date to show the beginning of the week rather than a number to display
which week it is in the year. Can someone give me the correct formula to put
in there to make it show this? Thanks Julie
 
M

Marshall Barton

Julie said:
I am writng a report to show assessments due on a weekly basis. I created
the report but in the Header of the Report where it will havve the assessment
referencedate group together by the week it is showing up as a number to
represent which week of the year it is. I want it to display the week as a
Sunday date to show the beginning of the week rather than a number to display
which week it is in the year. Can someone give me the correct formula to put
in there to make it show this?
Click to expand...


DateAdd("d", 1 - WeekDay(Date()), Date())
 

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

Need some PWA help 0
Show week number in Project Report 0
Report Group Footer DLookUp 0
Remote stopped working in PowerPoint Presenter View 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
week (WW) conversion to date in Access Graph 2
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0

Top