Adobe Experience Manager Forms

UKE87 · ‎15-02-2023

Hi experts,

I am not getting anywhere here.

The goal is to put out the number of individual weekdays days between two date fields.
In my form I could already generated a code, that put out the total number of working days in the entered period of datefield1 and datefield2.

How exactly can I realize that at the end is displayed for example:

Number of Mondays: 2
Number of Tuesdays: 2
Number of Wednesdays: 1

Here is my file:

https://www.acronaut.de/download/file.php?id=9980

Mayank_Gandhi · ‎17-02-2023

@UKE87

try this

var startDate = new Date('15/03/2022');
var endDate = new Date('25/03/2022');
var numOfDates = getBusinessDatesCount(startDate,endDate);

function getBusinessDatesCount(startDate, endDate) {
    let count = 0;
    const curDate = new Date(startDate.getTime());
    while (curDate <= endDate) {
        const dayOfWeek = curDate.getDay();
        if(dayOfWeek !== 0 && dayOfWeek !== 6) count++;
        curDate.setDate(curDate.getDate() + 1);
    }
    app.alert(count);
    return count;
}