Displaying only the last 5 day's records.

[rathi]

Hi,

I can use the

Select * from tblInvoice where trx_date between date1 and date2.


Here date1 is today, date 2 is 5 days before today.

How can calculate the date 2? Is there any function to do this?

Pls. reply if you have any idea.

sincerely,

rathi