HELP! - Date Issues

B

Beaty

Joined
Jun 11, 2010
Messages
1
Reaction score
0
Hi Guys,

I am hitting my head off the desk with this... The field in the database is a Medium Date

Code: 
SELECT DatePart("yy",[Testing Complete]) AS YearComp, [Staging Table].[Testing Complete], [Staging Table].[Job No]
FROM [Staging Table]
WHERE ((([Staging Table].[Testing Complete]) Is Not Null));

Error
Code: 
Complie Error. In Query Expression 'DatePart("yy",[Testing Complete]'.

Microsoft Help may as well be in a Old Lanuage only known by the man who invented the wheel.
Code: 
 in query expression . (Error 3075)[/b]
 
The expression you typed is not valid for the reason indicated in the message. Make sure you have typed field names and punctuation correctly, and then try the operation again.[b]
Please someone help!!

Thanks
B
 
Back
Top