topic Re: Count number of days from different months in App Development

Count number of days from different months

Thabang231 — Tue, 06 Dec 2022 17:53:41 GMT

Hi Team I am looking for a solution, I currently want to do count from 2 date fields with different months,

here is the formula I'm using,

count(" To Date" - " From Date")

I am getting the correct count when the "To date" are on same month from "From date", but when months are different for instance count('2022-09-02' - '2022-08-31') should give us 3, not 2.

please assist. thanks in advance!

Re: Count number of days from different months

BrunPierre — Tue, 06 Dec 2022 22:39:27 GMT

The NetWorkDays function is worth checking out.

NetWorkDays ("To Date", " From Date") as [Days Taken during the week]

Re: Count number of days from different months

Thabang231 — Wed, 07 Dec 2022 06:28:25 GMT

@BrunPierre the networtkDays function i have used to get the during, and it works correct, now the issue is the total days taken including weekends on the different months, please look at my attachment.

Hope you can assist there.

Re: Count number of days from different months

vinieme12 — Wed, 07 Dec 2022 07:50:36 GMT

simply subtracting the two dates will return difference in days and adding +1 is sufficient as dates are just numbers

" To Date" - " From Date" + 1 as DateDiff

Also COUNT() as you are using will always return 1 and is incorrect,

Your count() might actually be returning the no of rows for that record and not the difference in days

Re: Count number of days from different months

Saurabh_K14999 — Tue, 20 Dec 2022 11:47:18 GMT

Hi,

Try this expression -

count(floor(Date#("To Date") - Date#("From Date"))) + 1

Regards,