We've recently moved from Sage 100 providex to SQL. Upon looking at our tables in SQL it appears that every field of type datetime now has been set to not allow null values. As a result all of those fields now automatically populate with 1753-01-01 (SQL's default in these kinds of situations). I can understand not allowing nulls for the crucial dates that pertain to that record but it seems rather odd for some fields that should not have a date in them unless some task has been completed or a date is warranted for that field (i.e. SO_salesorderheader's  Promoted Date, D404_PickDate, etc.).

I can easily modify the tables to allow nulls for those fields but I wanted to confirm whether or not this is normal behavior before I "fix" this?