I'm trying to display data on a graph where the X-axis is the week of the year. Easy enough. Format([DfcncyInspctDt],""ww" "yy"") will give me "5 '06, 6 '06," etc. I'd liek to format it differently, though. Something like the date of the Sunday the week starts on. Any clue how I'd get that? So instead of "5 '06, 6 '06," I'd want "1/29/2006, 2/5/2006," etc. Thanks for reading. Have a great weekend.
return the same value. After looking at Mike's code I guess that you don't need the if statement that I used. If the date is a sunday then strDate - myday + 1 will just be strDate. Without ramblilng too much, both solutions do the same thing but Mike's is a little cleaner.