Newbies Qaraj Posted November 18, 2022 Newbies Posted November 18, 2022 HI I have a solution I want to write a script or calculation that counts one day a week as vacation for 1 year, from a specific day forward. example .. every sunday until 2024
comment Posted November 18, 2022 Posted November 18, 2022 (edited) Could you be more specific with your requirements? Counting weeks is not the same thing as counting Sundays. What are the inputs to this calculation and what are the exact rules - esp. with regards to partial weeks? Edited November 18, 2022 by comment
Newbies Qaraj Posted November 20, 2022 Author Newbies Posted November 20, 2022 Thanks for your answer , here is a solution you can work with. This solution is similar to my original. If you check record 15, Erik has permission from. 2022-11-13 until 2022-11-27 if you add a new record with date/time it will be green until the end date 2022-11-27 I want a secript for permission where a person can have every Monday off, e.g. until the year 2023 and the field perm shows green fpattandance.fmp12
comment Posted November 20, 2022 Posted November 20, 2022 (edited) Sorry, I have no idea what you mean. Edited November 20, 2022 by comment
comment Posted November 20, 2022 Posted November 20, 2022 (edited) Here you can find a calculation that allows you to count how many Mondays (or any other day of week) are in a given range: https://fmforums.com/topic/42435-of-fridays-in-a-given-time-period/?do=findComment&comment=197966&_rid=72594 Here is a custom function that returns a list of those days: https://www.briandunning.com/cf/452 If neither of these answer your question, you will have to be much more specific. Edited November 21, 2022 by comment
Recommended Posts
This topic is 986 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now