since ‎08-01-2018
‎10-12-2019
Afridi198500
Level 1
Re: Total Days between two Dates Excluding Weekends in LCD
Avatar

Afridi198500

Afridi198500
- Adobe LiveCycle
jahantech your prompt replies are really highly appreciated. very sorry to say but could you or anybody please help me with providing an example of this complicated code.

Views

1.4K

Likes

0

Replies

0
Re: Total Days between two Dates Excluding Weekends in LCD
Avatar

Afridi198500

Afridi198500
- Adobe LiveCycle
now im very sorry to add one more question here but its urgent pleasei also want to exclude the public holidays (solar and lunar) how could i do it?

Views

1.4K

Likes

0

Replies

0
Re: Total Days between two Dates Excluding Weekends in LCD
Avatar

Afridi198500

Afridi198500
- Adobe LiveCycle
dear jahantech,the follwoing code worked like a charm!.... i just added "-1" in the end of the following line:var toDateAsNum =Date2Num(toDate, "YYYY-MM-DD", "en_IE")-1.

Views

1.4K

Likes

0

Replies

0
Re: Total Days between two Dates Excluding Weekends in LCD
Avatar

Afridi198500

Afridi198500
- Adobe LiveCycle
jahntech, many thanks for prompt replies..now it is showing 6 working days if a person leaves on 1 apr 2018 and back to work on (Date2) 8 apr 2018.i want it to show 5 days and two weekend days (Fri and Sat) .... keep in mind that Date2 is joining date which means that the total days should subtract one day from the joining date.could you please help?

Views

1.4K

Likes

0

Replies

0
Total Days between two Dates Excluding Weekends in LCD
Avatar

Afridi198500

Afridi198500
- Adobe LiveCycle
Want to get total days from two dates Date1Date2the total days should exclude weekends "Fridays" and "Saturdays"I'm pushing the script in properties of the Total field.could anybody check if I'm doing something wrong because the calculation is not showing the correct number.the code is given below:// get the end date valuevar Date2 = this.getField("Date1").value;// get the start date valuevar Date1 = this.getField("Date2").value;var dDate1 = util.scand("dd/mmm/yyyy", Date1);var dDate2 =util.scan...

Views

4.1K

Likes

0

Replies

8
Re: Calculating Total Number of Days +1
Avatar

Afridi198500

Afridi198500
- Adobe LiveCycle
if (StartDate=="" || EndDate=="") event.value = "";else { // do the rest of the calculation}

Views

531

Likes

0

Replies

0
Likes given to