Re: Filter for previous month
Posted: Tue Feb 28, 2017 2:26 pm
Aleksey wrote: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