Always display records from previous 3 months

[NEL3644]

What's the query statement that will always display records from previous 3 months. Will anyone please help me?

 

[NeoTurtle]

Sort months in descending order and set MAXROWS to 3 months in your query . . . that's if you have months as a field in your database.

hope this helps,
-NeoTurtle

 

[perichazhi]

First of all your database table should have a date field which captures the date of transaction.

If your database is SQL Server use the query below

select * from tablename
where datefield > dateadd(mm,-3,getdate())

if oracle then use

select * from tablename
where datefield > sysdate-30