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?

[Anurag Tripathi]

you can try for

created   <between> <start date of your choice> and <end date of your choice>

[Julian Hoch]

I forgot to add that it's a scheduled report, and I cannot expect the users to edit the report every month just to keep the dates correct.

[Anurag Tripathi]

schedule a report on 1st of every month and in the report filter the records created on last month

[PrashantLearnIT]

Hi Julian,

                            You can use "sys_created_onONLast month@javascript:gs.beginningOfLastMonth()@javascript:gs.endOfLastMonth()";

Thanks

Prashant