Hello,
I'm struggling to find or write a SQL or .net function or SSRS expression to calculate working days between a CreatedDate and ClosedDate, the function must include bank holiday dates.
I'm working from a database where creating SQL functions are not permitted, however I can embed the SQL in the dataset and can create a lookup table for the bank holiday dates.
I'm hoping someone has one to share or can help me create one?
Any help appreciated.
Thanks,
Javedi
I'm struggling to find or write a SQL or .net function or SSRS expression to calculate working days between a CreatedDate and ClosedDate, the function must include bank holiday dates.
I'm working from a database where creating SQL functions are not permitted, however I can embed the SQL in the dataset and can create a lookup table for the bank holiday dates.
I'm hoping someone has one to share or can help me create one?
Any help appreciated.
Thanks,
Javedi