Forums

Hi Everyone, I have a client with a requirement for a report that uses a running date range from the current month to six months from the current month. They want the month they are running the report in to be the starting month, and the end month should be six months from the current month, this being evaluated against a date field in Maximizer. Is there a way to filter the data this way when reading the data through the API?

I can see that we can use $THISMONTH() in the search criteria which helps with the start month, but is there some way to say $THISMONTH()+6 as an example for the end month? We only need six months worth of data.