Collect information over the last x days? 1

[NavMen]

Hi

I try to collect all tranactions of today with the following query and that works fine, but now I try to get information from the last 7 days and I don't get it to work.

select * from STH_POL_REPORT where date = CONVERT(varchar(30),getdate(),101)

Date field format is: 02/28/2008 (dd/mm/yyyy)

Also how can you generate a list of transaction per month?

Thanks,

Navmen

 

[bborissov]

02/28/2008 (dd/mm/yyyy)???
I never saw 28 month

SELECT *
       FROM STH_POL_REPORT
WHERE Date >= DateAdd(dd,DateDiff(dd,0,GETDATE()),-7)

That would give you ALL transactions from midnight of the day before 7 up to now.

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[NavMen]

Thanks that works fine!
It is mm/dd/yyyy, Slip of the finger


What about montly reporting of the tranactions?

/Navmen

 

[bborissov]

Start a new thread. I am not a reporting guy

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP