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 michael.wh...@verizon.com <mailto:michael.wh...@verizon.com> Office 813.978.2192 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Jon Chau Sent: Thursday, July 01, 2010 2:46 PM To: arslist@ARSLIST.ORG 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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
