Skip to Content
avatar image
Former Member

Selecting previous month/year

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers