Jump to content

Report using something like startoflastmonth


Recommended Posts

Hi All,

I am trying to create some reports and some widgets that will return details about the previous calendar month. In Supportworks I would do something like:

DateField > startoflastmonth AND DateField < endoflastmonth

I'm trying to find any documentation about if there is something similar in Service Manager reports and widgets but am so far coming up short. Is this because that functionality no longer exists?



Link to comment
Share on other sites

Hi @chrisnutt

We are working on some exciting new features around Reporting and using variables such as startoflastmonth within reports is included, i can't confirm when they are going to be available but as soon as i have some news i will update this thread, i can at least confirm this is in our 90 day window of future changes.

Kind Regards

Trevor Killick 

Link to comment
Share on other sites

  • 2 weeks later...

Hi @chrisnutt

In the interim whilst we are waiting for the new functionality, there are ways you can do this using some standard MySQL statements and the "Use Custom Criteria" option. 

For example, if I was looking for All Requests Logged Last Month (without specifying the specific dates) we can do this using the where clause:

h_datelogged < LAST_DAY(NOW() - INTERVAL 1 MONTH)

This is configured in reporting as per my screenshot below. This is using a function to get the current date and from that working out the first and last days of last month. 

We don't currently have this documented anywhere as its more standard SQL functions, but I will work on creating an FAQ in the next few weeks and posting back to this post. 



Kind Regards





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...