I am using SSRS.

thanks

Thank you

thank you 🙂

That works perfectly thank you so much.

Also If i wanted to add in more criteria do i just simply add them into the Where statement.

thanks again

Thank you so much that worked perfectly.

I am currently using Time datatype which i think is causing the issue.

If i was to change my database to datatime datatype would could i get it to just show...

Hi,

thank you for your reply.

I have a start roster date however if someone works 21:00 - 06:00 then I need the date date to change to the next day.

i.e 10-12-2015...

Using the above function is there a way to do an IF statement with it. As i am dealing with a call center that work different hours.

0900-1700

0900-1500

0930-1730

1200-1700

1300-1600

2115-0015

1630-0115

0045-0915

thank you

That is perfect.

thank you so much for your help 🙂

Hi,

How do I use this function? (sorry quiet new to SQL so still learning).

Also would it matter that it is a TIME datatype rather then DateTime.

Thank you for your help.