Date Formats-Weeks in Date No

[Guest]

Good morning,

I have a graph that runs from a query. Recipients of a group wanted data
shown in weeks so I entered:
Week No: (Format([DateIR],"ww"" '""yy"))
Results were: 1 '07; 2 '07; 3 '07 etc.

They would like to see the 'week period' i.e. 'Jan 1-Jan 6' say, rather than
the 'week number'. Can someone please advise me how you enter it to get the
this information. The graph runs by week for the whole year.

Thank you,
IEJ

 

[Guest]

This might be what you are looking for. Change [datStart] to your date
field.
Format([datStart]-Format([datStart],"w")+2,"mmm d") & " - " &
Format([datStart]-Format([datStart],"w")+6,"mmm d")

 

[Guest]

Good morning,

Thank you. I'll give it a try and see if it works.

Regards,
IEJ

This might be what you are looking for. Change [datStart] to your date
field.
Format([datStart]-Format([datStart],"w")+2,"mmm d") & " - " &
Format([datStart]-Format([datStart],"w")+6,"mmm d")
--
KARL DEWEY
Build a little - Test a little

Good morning,

I have a graph that runs from a query. Recipients of a group wanted data
shown in weeks so I entered:
Week No: (Format([DateIR],"ww"" '""yy"))
Results were: 1 '07; 2 '07; 3 '07 etc.

They would like to see the 'week period' i.e. 'Jan 1-Jan 6' say, rather than
the 'week number'. Can someone please advise me how you enter it to get the
this information. The graph runs by week for the whole year.

Thank you,
IEJ