Jump to content

Every day of week


Qaraj

This topic is 494 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

 

Link to comment
Share on other sites

  • Newbies

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

Link to comment
Share on other sites

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 by comment
Link to comment
Share on other sites

This topic is 494 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.