BETWEEN now() - 6days???? AND now()

[theJonster]

Hi,

Tryin to get records between these two dates, 6 days ago and now.

Thanks

[mabubakarpk]

If your are using SQL Server then use this query

            Select * from tablename where tdate between getdate()-6 and getdate()

Note: getdate() returns current date time.