I am trying to filter out records in my salesforce report like i just want to see last month records (Created Date).

See below what i have done so far,

Date filter on Created Date > CUSTOM > 02-Jun-2020 - 01-Jul-2020 (but this is static)

Can anyone please guide me How can i put this filter dynamic in report like 02-LastMonth-2020 - 01-CurrentMonth-2020 ?

Thank you...


You can filter by custom range and select last month as option value or last 30 days.

enter image description here

enter image description here


To filter out by specifying the month name, You can create a custom formula field on the object which returns the month of the createddate field. Later you can use this field to filter in the report.

  • Hey Sanket, but how can you put a dynamic month in this filter? – Nail David Jul 7 '20 at 10:44
  • check out my update please. – sanket kumar Jul 7 '20 at 12:29

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.