By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,962 Members | 1,998 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,962 IT Pros & Developers. It's quick & easy.

Formatting Report Date

P: n/a
Hi,

I have a report that sorts by week - however access uses:

=Format$([actualDelivery],"ww",0,0)

To output the week number. I want to display the week commencing date -
i.e. The First Monday of the week that the date 'actualDelivery'
resides in.

Any help is greatly appreciated.

Oct 30 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a

Hi,

this works for me. I admit, there are probably less
rocketscientist-looking solutions.

DateAdd("d", -1 * (WeekDay(a, vbMonday) - 1), a)

Rudi.

Ps, I'm no rocket-scientist!

Oct 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.