Adobe Community: Calculate the number of week days between two dates

Currently Being Moderated

1. Steve L Walker,

May 10, 2009 9:21 PM in reply to Jo_2005

Report

Try this....

// form1.page1.subform1.WeekEndDays::calculate - (FormCalc, client)

if (HasValue(Start_Date1) & HasValue(End_Date1) ) then
    var totalDays = Date2Num(End_Date1, "YYYY-MM-DD", "en_IE") - Date2Num(Start_Date1, "YYYY-MM-DD", "en_IE") + 1
    var currentDateNum = Date2Num(Start_Date1.formattedValue,"YYYY-MM-DD")
    var dayCnt = 0
    for i=1 upTo totalDays do
        var dayOfWeek = Num2Date(currentDateNum,"E")
        if (dayOfWeek == 1 | dayOfWeek == 7) then
            dayCnt = dayCnt + 1
        endif
        currentDateNum = currentDateNum + 1
    endfor
    $ = dayCnt
else
    ""
endif

Steve

Attachments:

CalculateWeekDays.pdf (81.4 K)

|

Mark as:

Currently Being Moderated

2. Jo_2005,

May 10, 2009 10:30 PM in reply to Steve L Walker

Report

Dear Steve,

Thank you very much for your reply. I have placed the script into my calculation field called "days1".

There is an error message when the pdf is previewed.

I have attached the error message on a file for you to look at to see where I could be going wrong.

eg. syntax error near token " on line 2, column 0.

Thank you for your assistance.

Attachments:

script failed.pdf (39.4 K)

|

Mark as:

Currently Being Moderated

3. Steve L Walker,

May 11, 2009 9:08 AM in reply to Jo_2005

Report

Check...

1) You stated you put the script on the calculate event of "days1". My sample mimics the variable names used in the original post, "Start_Date1" and "End_Date1". If the variable names for the start and end dates are different you will have to change the script to reflect those names.

2) The Date2Num functions in the calculation of "totalDays" uses the date format "YYYY-MM-DD". If your date patterns differ from "YYYY-MM-DD" FormCalc will complain.

Steve

|

Mark as:

Currently Being Moderated

4. Jo_2005,

May 11, 2009 6:58 PM in reply to Steve L Walker

Report

Hello Steve,

I have changed the display and validation pattern in the fields of Start_Date1 and End_Date1 to YYYY-MM-DD and the scripting works a treat.

Thank you very much for all of your help Steve, it is very much appreciated.

|

Mark as:

Currently Being Moderated

5. Jo_2005,

May 11, 2009 9:13 PM in reply to Steve L Walker

Report

Hello Steve,

I have one last question for you.

I would like to change the date format from YYYY-MM-DD to DD-MM-YYYY.

The Start_Date1 and End_Date1 pattern fields have been changed to the new format of DD-MM-YYYY.

I have also revised the form calcs in Weekend Days and Total Days to the format of DD-MM-YYYY.

The script will not calculate the number of days after changing the date format.

Can you please advise what the problem could be?

Thank you once again, Steve.

|

Mark as:

Currently Being Moderated

6. Steve L Walker,

May 11, 2009 9:32 PM in reply to Jo_2005

Report

The attached now displays the start and end dates as DD-MM-YYYY. I added script to validate the end date is greater than the start date, also.

Steve

Attachments:

CalculateWeekDays-v1dot1.pdf (81.8 K)

|

Mark as:

Currently Being Moderated

7. Jo_2005,

May 11, 2009 10:24 PM in reply to Steve L Walker

Report

Hello Steve,

I have adapted the changes to the script in my form and the number of working days are now calculating between the two dates.

Thank you Steve, you are an absolute legend.

|

Mark as:

Currently Being Moderated

8. Jo_2005,

May 12, 2009 9:17 PM in reply to Steve L Walker

Report

Hello Steve,

I have revised the script to take into account that if the start date and end date are the same that the total of days will = 1.

Before being revised the script would not calculate the number of days if start and end date were the same.

The revised script is posted as below for reference:

// Weekdays field *This will subtract the total days - the weekend days to give the total number of weekdays between two dates*

if (HasValue(Start_Date1) & HasValue(End_Date1) ) then

if (Date2Num(End_Date1, "YYYY-MM-DD", "en_IE") >= Date2Num(Start_Date1, "YYYY-MM-DD", "en_IE")) then

$ = TotalDays1 - WeekEndDays1

else

""

endif

else

""

endif

// Weekend Field *this will calculate the number of weekend days between two dates*

if

(HasValue(Start_Date1) & HasValue(End_Date1) ) then

if (Date2Num(End_Date1, "YYYY-MM-DD", "en_IE") >= Date2Num(Start_Date1, "YYYY-MM-DD", "en_IE")) then

var totalDays = Date2Num(End_Date1, "YYYY-MM-DD", "en_IE") - Date2Num(Start_Date1, "YYYY-MM-DD", "en_IE") + 1

var currentDateNum = Date2Num(Start_Date1.formattedValue, "DD-MM-YYYY")

var dayCnt = 0

for i=1 upTo totalDays do

var dayOfWeek = Num2Date(currentDateNum, "E")

if (dayOfWeek == 1 | dayOfWeek == 7) then

dayCnt

= dayCnt + 1

endif

currentDateNum

= currentDateNum + 1

endfor

$ =

dayCnt

else

""

endif

else

""

endif

// Total Days Field - *This will calculate the total number of days including weekend days*

if

(HasValue(Start_Date1) & HasValue(End_Date1) ) then

if (Date2Num(End_Date1, "YYYY-MM-DD", "en_IE") >= Date2Num(Start_Date1, "YYYY-MM-DD", "en_IE")) then

$

= Date2Num(End_Date1, "YYYY-MM-DD", "en_IE") - Date2Num(Start_Date1, "YYYY-MM-DD", "en_IE") + 1

else

""

endif

else

""

endif

|

Mark as:

Currently Being Moderated

9. shyamkg,

Dec 26, 2011 10:43 PM in reply to Steve L Walker

Report

Sir,

Belated Merry Christmas...

Just today (27-12-2011) I have come across your solution for calculating the number of weekdays between two dates. It is working perfect.

But I have a small problem. I am residing in Middle East (Dubai - U.A.E). Here the weekends are Friday and Saturday.

If I want to know the number of weekdays between 13-Jan-2012 and 20-Jan-2012, your solution will show 6 days, whereas actual is only 5.

How can I modify the script to consider the weekends as Friday and Saturday. Your kind reply would be highly appreciated.

Regards

Shyam Kumar

shyamkg@hotmail.com

|

Mark as:

$Niall O\'Donovan$

Currently Being Moderated

10. Niall O\'Donovan,

Dec 27, 2011 3:39 AM in reply to shyamkg

Report

Hi,

If you have a look at the script, you will see an if statement that is testing the day of the week. Sunday=1 and Saturday=7. You just need to change the 1 to a 6.

if (dayOfWeek == 6 | dayOfWeek == 7) then

dayCnt = dayCnt + 1

endif

Good luck,

Niall

|

Mark as:

Currently Being Moderated

11. shyamkg,

Dec 27, 2011 4:38 AM in reply to Niall O\'Donovan

Report

Great !! Niall, it worked..Thanks..

Wish you a great year ahead...

Shyam

|

Mark as:

LiveCycle Designer

Calculate the number of week days between two dates

May 10, 2009 5:54 PM

More Like This

Bookmarked By (0)

Answers + Points = Status