topic Re: Calculation between Dates - Networkdays in App Development

Calculation between Dates - Networkdays

jerryr125 — Fri, 20 Aug 2021 15:57:34 GMT

Hi -

Question:

On my dataload I am creating a field to calculate number of days between two days.

Field: PRDate

Format: mm/dd/yyyy

Example: 7/08/2021

Field: WDate

Format: mm/dd/yyyy

Example: 6/29/2021

Formula:

Floor(PRDate)-floor(WDate)

Value: 9

Formula:

NetWorkDays(PRDate,WDate)

Value: 0

Why does the Formula for NetWorkDays display 0 ?

I would think the value should be 7

Any thoughts ?

Re: Calculation between Dates - Networkdays

Kushal_Chawda — Fri, 20 Aug 2021 16:55:19 GMT

@jerryr125 Networkday function takes the first parameter as start date and second parameter as End date. In your case you need to reverse the Dates like below

NetWorkDays(WDate,PRDate)

Re: Calculation between Dates - Networkdays

jerryr125 — Fri, 20 Aug 2021 17:28:17 GMT

Excellent -thank you ! Works perfectly!