?getweekno(DATE(2019,12,31)) Return = 1 FUNCTION GetWeekNo LPARAMETERS ldDate lnJulian = VAL(SYS(11,ldDate))+1 lnDay4 = MOD(MOD(MOD((lnJulian+31741 - MOD(lnJulian,7)),146097),36524),1461) lnLeap = INT(lnDay4/1460) lnDay1 = MOD(lnDay4-lnLeap,365) + lnLeap RETURN INT(lnDay1/7)+1 ENDFUNCthe same work great for 31.12.2021, 31.12.2020, but for 31.12.2019 they return : 1
?WEEK(DATE(2019,12,31),2,2) Result = 1Why ?