Date Formats-Weeks in Date No

N

nutmeg

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
 
K

KARL DEWEY

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")
 
N

nutmeg

Good morning,

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

Regards,
IEJ

KARL DEWEY said:
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


[email protected] said:
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
Click to expand...
Click to expand...
 
Top