week of the year

Jean-Pierre Radley appl at jpr.com
Tue May 12 14:46:44 PDT 2015


Don Bush propounded (on Tue, May 12, 2015 at 04:12:25PM -0500):
| Is there a FilePro function that will give the week of the year based on the
| ISO 8601 Calendar.
|    * Week numbers: ISO 8601 (week starts Monday) - week 1 is the first week
| with Thursday
|    * Dec 28 is always the last week of the year no matter what day of the
| week it is.

It sure ain't a standard filePro function, but it sounds like a nice
little "exercise for the student" to write a processing table for such a
function.  All you need is some calculation which returns 0, +1, or -1 
to add to fP's WOY function to get a new ISO.8601-compliant WOY.

-- 
JP


More information about the Filepro-list mailing list