Forum Discussion

Lee_Mather's avatar
Lee_Mather
Regular Visitor
10 years ago

Advice Required: Data Spanning Months

Does anyone have any tips on how I can split a data field into two seperate months   I have a start date and an end date.  Where the start and end date cross into 2 seperate months I need to pro ra...
Tips and Tricks
Tutorial Requests
Lee_Mather's avatar
Lee_Mather
Regular Visitor
10 years ago

I found the answer, work with the date table, add a weekday counter, 1 for weekdays, 0 for weekends and bank holidays then do a sum calculation based on the start and end date.

 

Thanks to Rob Collies blog post for this heads up.

 

Lee