Re: DateDiff to determine number of weekdays past?

[Shannon Carr]

I tried 'w' but it is returning records more than 3 days old.

I found the following earlier:

When datepart is Weekday ("w"), DateDiff returns the number of weeks between the two dates. If date1 falls on a Monday, DateDiff counts the number of Mondays until date2. It counts date2 but not date1.

http://www.houseoffusion.com/lists.cfm/link=m:4:26521:133333

Shannon

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---