Month & Year Match Required

[ooch1]

Hello,

I was hoping that someone could provid me with a formula for matching to dates, by month and year only/

I have tried format([date1],"mmyyyy")=format([date2],"mmyyyy"), but i assume this keeps the original dates and just makes them look different.

OOch

 

[johnherman]

try YEAR(date1) = YEAR(date2) AND MONTH(date1) = MONTH(date2)

-------------------------
The trouble with doing something right the first time is that noboby appreciates how difficult it was.
- Steven Wright

 

[SQLBill]

I gotta ask.....

Since you posted this

format([date1],"mmyyyy")=format([date2],"mmyyyy"),

and Microsoft SQL Server (to my knowledge) does not use that syntax, have you posted in the wrong forum? This is for Microsoft SQL Server: Programming.

-SQLBill

Posting advice: FAQ481-4875

 

[ooch1]

sql bill,

Since you asked, it is most definetly SQL, however when i have used it previously and the query ran fine, it was in the following context:

TRANSFORM nz(Sum([Number of MPANs]),0) AS Expr1
SELECT [SNFs].[New/Renewal], "02-MPANs" AS Proposal
FROM SNFs, Celendar
WHERE (((nz([Start Date])) Between Celendar![Month Start date] And Celendar![Month end date]) And (([SNFs].[Sales Channel Description]) Like "*conn*"))
GROUP BY [SNFs].[New/Renewal], "02-MPANs"
ORDER BY Format([Month],"mmmyy")
PIVOT Format([Month],"mmmyy") In ('Jan04','Feb04','Mar04','Apr04','May04','Jun04','Jul04','Aug04','Sep04','Oct04','Nov04','Dec04','Jan05','Feb05','Mar05','Apr05','May05','Jun05','Jul05','Aug05','Sep05','Oct05','Nov05','Dec05');

I hope this answers your query.

OOch

 

[r937]

TRANSFORM?

that's microsoft access, not sql server



rudy | r937.com | Ask the Expert | Premium SQL Articles
SQL for Database-Driven Web Sites (next course starts March 6 2005)

 

[ooch1]

Folks, you are quite correct i am in the wrong forum.

Apologies, but thanks anyway!!!

OOch