Skip to main content
Manolo Garcia Carrasco
Manolo Garcia Carrasco
Participating Frequently
June 10, 2021
Answered

calculate week number of year

  • June 10, 2021
  • 2 replies
  • 4524 views

Hello, I need to calculate the number of weeks in a year from a date entered in a field.

This topic has been closed for replies.
Correct answer try67

It works very well but I need the result to be in double digits.
For example:
If I type 210916 the result is 37, but if I type 220103 the result is 1, this result is correct but I am interested that it is 01.

JANUARY > 01
FEBRUARY > 02
MARCH > 03
APRIL > 04
MAY > 05...


After this line:

event.value = getWeekNumber(d);

Add this:

if (event.value.length==1) event.value = "0"+event.value;

2 replies

bebarth
Community Expert
bebarthCommunity Expert
Community Expert
June 11, 2021

Here is the adaptation to the US date format of a file shared on the French forum a few years ago.
The next year with 53 weeks will be in 2026 (the previous one was in 2020).
@+

    Manolo Garcia Carrasco
    Manolo Garcia CarrascoAuthor
    Participating Frequently
    July 30, 2021

    What I really need is that from a date field (DATE) I get the result in another field (WEEK).

    try67
    Community Expert
    try67Community Expert
    Community Expert
    August 3, 2021

    What I really need is that from a date field (MYDATE) get the week number of the year where the result appears another field (WEEK).
    For example:
    MYDATE (yymmdd): 210803
    WEEK: 31


    You can use this code, based on the function you provided above, as the custom Calculation script of the WEEK field:

     

    var s = this.getField("MYDATE").valueAsString;
if (s=="") event.value = "";
else {
	var d = util.scand("yymmdd", s);
	event.value = getWeekNumber(d);
}

function getWeekNumber(date) {
	date.setHours(0, 0, 0, 0);
	// Thursday in current week decides the year.
	date.setDate(date.getDate() + 3 - (date.getDay() + 6) % 7);
	// January 4 is always in week 1.
	var week1 = new Date(date.getFullYear(), 0, 4);
	// Adjust to Thursday in week 1 and count number of weeks from date to week1.
	return 1 + Math.round(((date.getTime() - week1.getTime()) / 86400000
		- 3 + (week1.getDay() + 6) % 7) / 7);
}

     

    try67
    Community Expert
    try67Community Expert
    Community Expert
    June 10, 2021

    Google: "javascript get week number from date"

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices