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.
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
The first time I see a person used a function type variable, i never imagine it is exist. Thank you sunny.
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.
Hi Sunny, very good tutorial - thank you. Can you also make a tutorial with public holiday?
It would be great to see the holiday exclusions. Great example......Thanks.
Please do a follow on video to show how to count excluding holidays! Thanks very much
Very good tutorial. please show the public holiday function.
Yes, please Sunny, could you show how to exclude holidays.
Hi Sunny, I just did your calculation step by step but dialog shows only question mark. any ideas?
How did you do it be4 filemaker 2018. I use 2015 and the while is not included.
Regards
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.
@@FMBeginner solved with this: 5 * Int ( ( EndDate - StartDate ) / 7 ) +Middle ( "0012345501234544012343340123223401211234010012340" ; 7 * (DayOfWeek ( StartDate ) - 1 ) + DayOfWeek ( EndDate ) ; 1 )
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
unfortunately Sunny is not active creating tutorial in filemaker no update since 3 years of his channel :(
ive done it but the number of working days arent correct
please count excluding holiday
Please follow up