Skip to Content
0

Selecting previous month/year

May 08 at 12:54 PM

10

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers