04-20-2017 05:49 AM
I am working in enyterprise guide 9.1 i am trying to identify how i can calulate the time between to given dates not including weekends and going forward bank holidays.
I lknow i can use the INTCK function this works great for the number of hours elapsed but does not consider weekends, i know there is a weekday element but this does not work its like i need workhours can anyone help?
04-20-2017 06:04 AM
Hey thanks for this i think that would help when i get to the bank holiday stage, What about hours this is where i am struggling with at the moment?
04-20-2017 06:42 AM
It's essentially the same as the blog post, but INTCK can take an hour parameter and you should have datetime variables not date variables.