by royaltiger » Fri Nov 04, 2016 2:39 pm
Although I have searched the site , I couldn't find a satisfactory answer or example of how to do the calculation. I do believe its complicated which is why its been difficult to find answer. The iso calculation which says the week begins on a Monday, and Thursday must be in the first week of the year comes into play, Leap years is another factor, when you research, you then realize its complicated, sometimes the first week of the year starts in the last week of December, sometimes there are 53 weeks in the year. I've seen examples of the calculation in other code language but it doesn't fit into the calculated field of Handbase. What would be the closest language code to use in the calculation ?