Thanks Phil, but i found a function to do it for me... DATENAME(). It takes 2 parameters, e.g:
DATENAME(m,hitdatetime) Next time i'll spend a little more time reading the documentation before posting. :) _______________________ James Silva Web Production Gruden Pty Ltd Tel: +61 02 9956 6388 Fax: +61 02 9956 8433 Email: [EMAIL PROTECTED] Web: www.gruden.com _______________________ --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
