I think it is the first date possible for the "smalldatetime" data type. I'm guessing you are populating with a default value - as in Dave's suggestion (putting in a time with no date would "default" to the earliest date maybe).
-----Original Message----- From: Torrent Girl [mailto:moniqueb...@gmail.com] Sent: Thursday, August 08, 2013 10:13 PM To: cf-talk Subject: 1900/01/01 Anyone know why 1900/01/01 would show up in a column when a record is updated? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:356425 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm