Toni Posted February 22, 2018 Posted February 22, 2018 Calendar View File I created this solution because I wanted to have each day as a record. The purpose of it, is assigning working days (business days) an incremental number so that number can be used in other related tables on which is required to calculate working days. It has two main scripts, the firsts populates the year. After year is populated, than holiday days are assigned manually but you can add script at your needs. I left it manually so you can be flexible with it. Where I live is not uncommon to have to work even if it might be a holiday, so every company has different needs. After holidays have been assigned, there is a second script which will define the incremental number of working days. On the holidays this number is equal to the number the nearest next working day has. For example, if 28 and 29 of November are holidays the working day for those will be 282 the same as that on 30 November. This helps in cases someone assigns a job that starts on holiday and calculate the end date of that job. Any idea or contribution to make it better is welcomed. Thank you, Toni Submitter Toni Submitted 02/22/2018 Category Samples FM Version 12
Recommended Posts
This topic is 2718 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