I am trying to select previous month in a filter in IDT
I have a database which uploads once a month and I have a filter for selecting max month which is:
AspireXML.dbo.tbReturn.dtPeriodEnd=(Select max(AspireXML.dbo.tbReturn.dtPeriodEnd) from AspireXML.dbo.tbReturn)
I know need to create a filter for previous month or previous year.
I have tried with -1 on end but doesn't work.
Thanks