Sorry guys, I've just tried datepart as well, and get the same error (i.e. invalid mysql syntax).
> I am not sure that MySQL supports the Year, Month, Day functions. I think > you have to use something like DatePart. > > CAVEAT: this is totally from memory and I didn't check the manuals. > > > Gary Menzel > Web Development Manager > IT Operations Brisbane -+- ABN AMRO Morgans Limited > Level 29, 123 Eagle Street BRISBANE QLD 4000 > PH: 07 333 44 828 FX: 07 3834 0828 > > > > > If this communication is not intended for you and you are not an authorised = > recipient of this email you are prohibited by law from dealing with or relyi= > ng on the email or any file attachments. This prohibition includes reading, = > printing, copying, re-transmitting, disseminating, storing or in any other w= > ay dealing or acting in reliance on the information. If you have received t= > his email in error, we request you contact ABN AMRO Morgans Limited immediat= > ely by returning the email to [EMAIL PROTECTED] and destroy the ori= > ginal. We will refund any reasonable costs associated with notifying ABN AMR= > O Morgans. This email is confidential and may contain privileged client info= > rmation. ABN AMRO Morgans has taken reasonable steps to ensure the accuracy = > and integrity of all its communications, including electronic communications= > , but accepts no liability for materials transmitted. Materials may also be = > transmitted without the knowledge of ABN AMRO Morgans. ABN AMRO Morgans Lim= > ited its directors and employees do not accept liability for the results of = > any actions taken or not on the basis of the information in this report. ABN= > AMRO Morgans Limited and its associates hold or may hold securities in the = > companies/trusts mentioned herein. Any recommendation is made on the basis = > of our research of the investment and may not suit the specific requirements= > of clients. Assessments of suitability to an individual=3Fs portfolio can = > only be made after an examination of the particular client=3Fs investments, = > financial circumstances and requirements. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
