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

Can I use A97 DateGrouping property to find Sunday date for any week?

P: n/a
The US default value for DateGrouping property in A97 is Sunday.
Knowing that, what's the simplest way to feed any date (MyDate)
to a FN and have it return the date of the first day of the week in
which it falls?

IE, feed #7/6/2005# to the FN and have it return #7/3/2005#
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Never mind. I found something out on the web that Getz came up
with that works nicely.

GetFirstDayOfWeek = dtDay - WeekDay(dtDay, vbWeekStartsOnDay) + 1
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.