Is there a setting to make smalldatetime or any date data type field default to NULL?
Currently it is defaulting to 1/1/1900 anytime the record is updated or inserted. I can set the default to the current date, but really we want that blank until it is filled in. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Microsoft DOTNET ASP, C++, SQL SERVER" group. ------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------- For stunning photoshop tutorials, visit: www.psd-help.blogspot.com ------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---