Greg, Sometimes you don't get a choice, I just checked what CFORM defaults to without any intervention and SQL Server is defaulting it to 01/01/1900.
-- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/108193156965451149543 On Sun, Sep 25, 2011 at 12:06 AM, Greg Morphis <gmorp...@gmail.com> wrote: > > I would just allow NULLs.. dealing with dummy dates is reallya bad deal.. > I'm working with a website 14 years old and the dummy dates are 1/1/1900 > and > sometimes 1/1/2000.. since the website expands the 2000 date range there's > trouble.. so just allow NULLs > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5614 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
