Why wont this DatePart Method work.

[rockyroad]

Why doesn't this work?

SELECT DownloadFile, TransactionType, TransactionDate
FROM Transaction
WHERE (DatePart("yyyy", [TransactionDate]) = 1999) AND (DatePart("mm", [TransactionDate]) = 7)

This works:
SELECT DownloadFile, TransactionType, TransactionDate
FROM Transaction
WHERE (DatePart("yyyy", [TransactionDate]) = 1999)

I just don't get it...

Thanks

 

[CajunCenturion]

Is there any reason why you're using "mm" instead of "m" for the second DatePart?

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[rockyroad]

OK, i think i figured this out, the DatePart method requires month as "m" not "mm" in Access.

 

[rockyroad]

Thanks. Now I just have to figure out why this EXACT same query will not work in a ColdFusion query. Time, well Dates specifically in this case, are not on my side here...