Code:
....> dateserial(year(today),month(today)-12,1)
C Tass
Last Activity: Feb 15 '12, 04:43 PM
Joined: Feb 1 '12
Location:
-
Date Query removing present month
In this code I am pulling particular totals for all 12 months off of a table. This is an on going query that pulls monthly. I want to exclude the current month from this query. How can I get it to not include current month but all previous? I know I need to exclude (today) part but I am not sure what to put in its place..
-
Problem with SQL Query
I am getting an error that my query is not properly ended Can someone tell me where I am going wrong with this.
Select ENG_ORD.ORD_CTL _NO, ENG_ORD.SER_NO, ENG_ORD.SHP_DT, ENG_ORD.SLS_MDL , ENG_ORD.ARR_NO, ENG_ORD.RTS_DT, ENG_ORD.DLR_CD
FROM ENG_ORD
WHERE (ENG_ORD.SHP_DT >='2012-01-26' AND ENG_ORD.SHP_DT< '2012-02-02') AND (ENG_ORD.DLR_CD LIKE '9GDM' OR ENG_ORD.DLR_CD LIKE 'B03%' OR ENG_ORD.DLR_CD LIKE 'Y157' OR...
No activity results to display