Jump to content

Current calls logged this month


Recommended Posts

Morning all,

I am trying to create a widget to tell me the current calls logged this month so far. so from the 1st nov to current date, I don't want to have to change the query every month to keep up and want it to roll each month.

So I have written this (I'm quite new to T-sql so it wont be right!):

(h_requesttype = 'Service Request' OR h_requesttype = 'Incident')

however its not working, is this anywhere near right? Could someone point me in the correct direction with this query, also is there a easier way to do it?






Link to comment
Share on other sites

Hey Victor, I have given this a go but it is not reporting correctly?

Today is the start of a new week and we have logged 16 calls so far this morning, however its not showing any as being logged? - I have refreshed it to make sure and still nothing.


This is the code we are currently using:


These are the logged calls so far today


Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...