This content has been marked as final. Show 3 replies
You can create a new calculated field as:
DATEADD('month', -1, [Order Date])
Use that in the view and everything will shift back 1 month.
Edited to fix a memory lapse
I ended up doing DATEADD('MONTH', -1, [OrderDate])