How to get last month issues

[upendra vemula]

I want to have filter to get last month issues, i mean, now we are in May, I wan to get the issues which captured in Apr, Do you have function like Created = LastMonth() ? 

[Jack Brickey · Accepted solution]

try this....

1. create this filter: createdDate < endOfMonth(-1) and createdDate >= startOfMonth(-1)
2. set up subscription to run monthly on the 1st of the month and email to you

[upendra vemula]

Thank you for your prompt response, It worked out for me,

[Jason Lane]

Hi,

Be mindful here this will not include the last day of the month so you'll need to amend the code to createdDate <= endOfMonth(-1) and createdDate >= startOfMonth(-1).

I did mine and went from 86 issues to 92 - when reviewing the rw output there was no data for the last day of the month hence the change.

Thanks

[Jack Brickey]

@Jason Lane ,

I was just testing this and using my query and it does (and should) pick up the last day. I am curious and would like to clear this in my head. Can you inspect your results and find the delta between the two queries? Thanks!

[Jack Brickey]

Here is what I see....

[Jason Lane]

Sorry i thought i had added to my post - I used a different date in mine and copied the wrong information over - Mine used was LiveDate <= endOfMonth(-1) and LiveDate >= startOfMonth(-1).

Interesting though that i had to make the change to the logic to get the information.

Sorry for the confusion. Jack is right with his but you need to ensure if you use a different date field that you check both.

Thanks

[Jason Lane]

Afternoon

Be mindful here this will not include the last day of the month so you'll need to amend the code to createdDate <= endOfMonth(-1) and createdDate >= startOfMonth(-1).

I did mine and went from 86 issues to 92 - when reviewing the rw output there was no data for the last day of the month hence the change.

Thanks

Jason