Hi, completely irrelevent but interesting all the same why is 17530101 the lowest possible value? Because this was the first complete year after the British Empire switched to the Gregorian calender.
To use an earlier date, you need to use a char or numeric data type and do the appropriate conversions yourself. cheers trent ---------- Original Message ---------------------------------- From: "James Silva" <[EMAIL PROTECTED]> Reply-To: "CFAussie Mailing List" <[EMAIL PROTECTED]> Date: Mon, 10 Mar 2003 13:46:37 +1100 >Heres the problem, after some testing, it seems that MSSQL doesnt like dates >before 1753. I need to support dates back to 1600. > >Any ideas? (i normally would do a lot more research before posting, but i need >to get back to the client asap). > >BTW, what's the practical date range/limit with CFMX? > >thanks in advance, >_______________________ >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/ > --- 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/
