Marinasout
asked on
empty date field in the datagrid
I have a column in SQL database table with date datatype. If user does not enter date in this field adding a new record the datagrid displays 1/1/1900. How can I avoid this and display an empty cell? Please, help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you sure the field is empty? The field should be NULL if it is truly empty. It looks like something is being added to the record as indicated by what usually is an invalid date "1/1/1900"?
ASKER
Hi, bladefist
you area right. Database puts that date as default. How can I check metadata?
you area right. Database puts that date as default. How can I check metadata?
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
No response from Marinasout from 12/12/2003 comment
Award points to bladefist is recommend.
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
planocz
EE Cleanup Volunteer
I will leave a recommendation in the Cleanup topic area that this question is:
No response from Marinasout from 12/12/2003 comment
Award points to bladefist is recommend.
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
planocz
EE Cleanup Volunteer
ASKER
Yes, the field was NULL and in this case it shows 1/1/1900. To avoid this i added requird field validator. Thank you. I accepted the answer.