Link to home
Start Free TrialLog in
Avatar of Marinasout
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
Avatar of bladefist
bladefist

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of ampapa
ampapa

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"?
Avatar of Marinasout

ASKER

Hi, bladefist
you area right. Database puts that date as default. How can I check metadata?
Avatar of Howard Cantrell
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
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.