well thank you so much for the help

yeah, i will change the date datatype into string and the other reason is that i dont need the hourly format

best regards,

ayi

well actually the date is null

but when the update button pressed, all the null date change to 1/01/1900

that is why i have been wondering whether i can use the select...

every null date type change into 1/01/1900

how to make the date null instead of empty

if the date null i can update database easily

is it a good idea to make the date dataype smalldatetime into string ?

because if the date = null or empty, it gives me 1/01/1900

which is i can not update...

i am developing aspx with c#

so where should i put the code

in the application level, you mean in the design

not in the code

and how i suppose to implement that

thank you