How to use the Work Calendar in a 2.0 User Event script to calculate the non-working days between two dates?

AI generated answer (using internal Slack threads):

****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ****** To use the Work Calendar in a 2.0 User Event script to calculate the non-working days between two dates, you would need to create a custom function that iterates through each day between the two dates and checks if it is a non-working day. Unfortunately, there is no direct way to access the Work Calendar via SuiteScript. However, you can create a custom record that mirrors your Work Calendar and use that in your script. Here's a general idea of how you could approach this: 1. Create a custom record that mirrors your Work Calendar. This record should have a date field and a boolean field to indicate if it's a working day or not. 2. In your User Event script, create a function that takes two dates as parameters. This function should iterate through each day between the two dates. 3. For each day, the function should look up the corresponding date in your custom record. If the boolean field for that date is false (indicating it's a non-working day), increment a counter. 4. At the end of the function, return the counter. This will be the number of non-working days between the two dates. Please note that this is a general approach and may need to be adjusted to fit your specific needs. Also, keep in mind that this approach assumes that your Work Calendar is static and doesn't change frequently. If your Work Calendar does change frequently, you would need to update your custom record accordingly.