Hi Greg,

Many thanks for replying - that seems like a good idea!  I'll explore it today.

Thank you,
Daz

Hi Thom,

Thanks for you reply - our reports have customer identifiable information sent directly to a broker, customer name, postcode.  They require this otherwise the reports are useless...

Thanks guys!  We are in the process of upgrading to 2016 so I might just wait it out and use the advanced features.

Thank you so much for the example code above - I think I'm close to cracking it using the article Thom provided.

I wasn't sure if the problem was solvable so...

Hi,

Sure, the FROMDATE field is the 1st day of the absence and the UNTILDATE field is the last day.

Example data:

FROMDATE UNTILDATEWORKDAYS

09/08/201606/09/201620

From what I've read on the below article I think...

Thanks for the reply - I'll have a read through and see if I can implement it via temp tables. Looks promising! 🙂

Thank you both, I've implemented the code and it works perfectly. I also now understand why the query wasn't recognising the SELECT Statement.

Many thanks!

Perfect, thank you Gila.

I was just missing the CAST clauses.

Thank you.

Hi Chris - it's a date time field. It comes from a poorly built off the shelf product. I've converted to date as I am pulling the data...

Thank you both! The solution works perfectly. I was trying to do it in a sub select, didn't think to put the same year of birth calculation in...

Hi Erikur

Many thanks for replying. What I am looking for is a way to do this without having to use expressions as it will take me ages to manually...

Randomly I have just fixed the issue.

I moved the last graph to the left so it overlapped the 2nd one and it worked! I have no idea why but...

No worries - I will keep playing around and hopefully I'll find a solution.

Hi - thanks for replying, I changed all the margins to zero and it still did the exact same thing unfortunately.

Hi Gazareth - I think I have sent you a PM - although it's not coming up in my sent items. Please let me know if I need to...