[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: ISO8601 Week number

[Sanjeva Manchala]

Hi Jens, Below code should work. DEFINE VARIABLE daysInYearSoFar AS INTEGER NO-UNDO . DEFINE VARIABLE weekNumber AS INTEGER NO-UNDO . DEFINE VARIABLE currentDate AS DATE NO-UNDO . currentDate = TODAY . daysInYearSoFar = currentDate - DATE ( 1 , 1 , YEAR ( currentDate ) ) + 1 . IF (daysInYearSoFar MODULO 7 ) = 0 THEN weekNumber = daysInYearSoFar / 7 . ELSE weekNumber = (daysInYearSoFar / 7 ) + 1 . Hope this helps, Sanjeev

Continue reading...