Null Values on Dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a DB which contains three date fields in which two of those fields
will be filled out by the end user in another country and one date field will
be left blank so i can enter the recived date when the DB is sent to me from
them. Would this cause a problem since i understand null values should not be
used to avoid any problems?
 
acss said:
I have a DB which contains three date fields in which two of those
fields will be filled out by the end user in another country and one
date field will be left blank so i can enter the recived date when
the DB is sent to me from them. Would this cause a problem since i
understand null values should not be used to avoid any problems?
Click to expand...

Who told you Null values are to be avoided?
 
Thanks Rick,

I did read on some postings that null values have differnt usage but i
guess in general allowing Nulls in a table will depend on exactly how you are
wishing to use the data. Is this correct?
 
acss said:
Thanks Rick,

I did read on some postings that null values have differnt usage but
i guess in general allowing Nulls in a table will depend on exactly
how you are wishing to use the data. Is this correct?
Click to expand...

If you read some of the "theory" groups there are varying opinions on Nulls
and dealing with them. If you poll 99.9% of people building real databases
you will find no such controversy.

Nulls represent unknown values. If you have a table that has some of the
data filled in at one point and additional data is provided at a later point
then having Nulls in those additional data fields until they are later
filled in is completely appropriate and will not cause any problems.
 
Back
Top