WOY Function for non-calendar weeks

Joe Chasan joe at magnatechonline.com
Mon Apr 5 07:52:22 PDT 2010


I have a process at a site that's been working fine dividing up
things based on WOY() function, which for most define a week as
Sunday through Saturday.

Now they want to redefine their work week as Monday through Sunday.  
WOY() takes no parameters but the subject date expression.  Does 
anyone have a routing already written that *efficiently* (key word
there) calculates WOY using other week start/end parameters?

--
-Joe Chasan-                           Magnatech Business Systems, Inc.
joe - at - magnatechonline -dot- com   Hicksville, NY - USA
http://www.MagnatechOnline.com         Tel.(516) 931-4444/Fax.(516) 931-1264


More information about the Filepro-list mailing list