Filter for previous month

[davidanthonyb]

Hello,

Please check the modified report in the attachment.

Thank you.

Hi Aleksey,

Thanks again for your help! That was almost perfect, but I did need to make 2 changes. I changed the first operator to >= instead of just greater than. I also noticed that in the report you sent, it was excluding any transactions from January 31st. To fix that, I removed the .AddDays(-1) from the end of the expression, and now all transactions from the previous month are showing correctly!

Code: Select all

(Table1.InventoryHistoryHistoryDateTime >= new DateTime(Today.Year, Today.Month, 1).AddMonths(-1)) && (Table1.InventoryHistoryHistoryDateTime < new DateTime(Today.Year, Today.Month, 1))

Thanks so much, helpful as always!
David

[Alex K.]

Hello

We are always glad to help you!
Please let us know if you need any additional help.

Thank you.