How can I filter on "created last month"?

[Julian Hoch]

I'm trying to create a filter on records that were created last month, that is between the beginning of last month and the start of this month.

I just cannot get this to work - I tried the "after last month" option, but that means everything after the END of last month, not the beginning of last month.

There is also no "two months ago" option.

Does anybody know how to do this?

[Julian Hoch]

Can I really enter scripts in my reports? I wouldn't know where to enter that.

[odijk]

I think this is the encoded query representation of:

which is a filter you can manually put together in your report.

[Erik Hoffmann · Accepted solution]

How about below?

Best regards,

Erik

[Julian Hoch]

Looks like you're right!

It seems it's so much simpler than I thought - the "Created on" is smart and includes all items in the whole month.