Thanks for that. I also just discovered DATENUM will return the number of the week if I want.
On Thu, Jul 1, 2010 at 12:09 PM, White, Michael W (MIKE) < [email protected]> wrote: > ** > > You can use the WEEKDAY function to return the weekday of a date/time field > (1-7, 1=Sunday). Use it for $TIMESTAMP$ to get current week day. > > > > For a quick-n-dirty solution, you could set a date field to: > > > > $TIMESTAMP$ - 60 * 60 * 24 * (WEEKDAY($TIMESTAMP$) - 1) > > > > This would set the field to the most recent week start date (Sunday), which > your target field could be compared to – to see if it’s greater than > (since). I’d use a date field to force time to 00:00:00. A date/time field > would need time delta from midnight stripped (a little fiddling). > > > > Mike White > > EMail [email protected] > > Office 813.978.2192 > > > > *From:* Action Request System discussion list(ARSList) [mailto: > [email protected]] *On Behalf Of *Jon Chau > *Sent:* Thursday, July 01, 2010 2:46 PM > *To:* [email protected] > *Subject:* Determining Current Work Week > > > > ** Hello Listers, > > > I'm a little stumped in trying to determine the best way to go check > whether a date/time field falls within the current work week. I thought > there would be a week function that return the week number of the calendar > year, and I could compare that result with the current date to the specified > date. There appears to be no such function. > > What other options do I have aside from writing and calling a SQL function > to check? > > Thanks, > Jon > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ > _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
