Hi All, I'm looking for help/advice in regards to calculating an end date for a variable period of time in minutes factoring in, working days, fixed working hours, fixed break times and holidays.
I've tried to work it out via queries but kept hitting either a "Query is too complex" issue (mainly due to my lack of knowledge :banghead or the date and finish time were just incorrect. I'm thinking maybe the best solution is to create a function around this, and in the meantime (while I continue struggle to put that together :banghead I wondered if any of you experts out there in this forum know if this has already been done before or you know how to put something like that together, so I can learn and adapt it to my db.
I hope this all makes sense and I would really appreciate any help on this as its driving me mad!
I've tried to work it out via queries but kept hitting either a "Query is too complex" issue (mainly due to my lack of knowledge :banghead or the date and finish time were just incorrect. I'm thinking maybe the best solution is to create a function around this, and in the meantime (while I continue struggle to put that together :banghead I wondered if any of you experts out there in this forum know if this has already been done before or you know how to put something like that together, so I can learn and adapt it to my db.
I hope this all makes sense and I would really appreciate any help on this as its driving me mad!