FileMaker Working Days Calculation

[@sarmednafi3277]

The first time I see a person used a function type variable, i never imagine it is exist. Thank you sunny.

[@FMBeginner]

Pleasure Sarmed! It kind of feels out of place with FileMaker scripting (this is more like general programming) so a lot of people don't know it exist too.

[@MeineFresse10]

Hi Sunny, very good tutorial - thank you. Can you also make a tutorial with public holiday?

[@billmushrush4831]

Please do a follow on video to show how to count excluding holidays! Thanks very much

[@jasonrogers8718]

It would be great to see the holiday exclusions. Great example......Thanks.

[@catringellhorn7940]

Yes, please Sunny, could you show how to exclude holidays.

[@scottlayden]

Very good tutorial. please show the public holiday function.

[@djmaeoyda4564]

Hi Sunny, I just did your calculation step by step but dialog shows only question mark. any ideas?

[@mrtau6279]

can you do one with counting days between multiple dates in a record (excluding weekends/holidays) for example: In a record I have 5 dates.. each date is later than the previous date and I want to count the days in between and add them at the end like shown: date1 to date2 = 3days date2 to date3 = 7days date3 to date4 = 5days date4 to date5 = 2days Total days = 17days

[@zeddotv]

unfortunately Sunny is not active creating tutorial in filemaker no update since 3 years of his channel :(

[@ioncorbu4071]

How did you do it be4 filemaker 2018. I use 2015 and the while is not included. Regards

[@FMBeginner]

You will need to learn how to use recursive function. Or additionally, with some slight twist, a loop might also be possible to do this.

[@ioncorbu4071]

@@FMBeginner solved with this: 5 * Int ( ( EndDate - StartDate ) / 7 ) +Middle ( "0012345501234544012343340123223401211234010012340" ; 7 * (DayOfWeek ( StartDate ) - 1 ) + DayOfWeek ( EndDate ) ; 1 )

[@klydiaschwendinger8483]

please count excluding holiday

[@djmaeoyda4564]

ive done it but the number of working days arent correct

[@pointblankunivercity1157]

Please follow up