Sorry to reply to myself, I forgot to clarify this:

I'm trying to use this SQL statement:

DATEFORMAT( "Sale Date", "MM-YYYY" ) AS "Sale Month

Which returns 'Access Denied'. I tried opening the SQL console and typing:

SELECT DATEFORMAT( '1989-01-01', 'Mmm dd, yyyy' );

which also throws an 'Access Denied' error. Whats going on here?

--
Christopher Stamper

Email: [EMAIL PROTECTED]
Web: http://tinyurl.com/2ooncg
gTalk: http://tinyurl.com/6e359r
Skype: cdstamper

Reply via email to