Dates in columns? 1

[tag141]

I have a list of people in a database. The db is being used as part of a project I am building in VB2005. I have a date of birth column but I cannot get dates to be in the format dd/mm/yyyy. If BOBs d.o.b is the first of May 2006 his DOB should read 01/03/2006. BUT in the db column it always reverts back to 1/03/2006 without a zero in front of the first 1 no matter how you type it in. I've tried input masks and formats but nothing seems to work.

Any ideas?

 

[tag141]

OK, give myself a pink star please. Don't know why it wouldn't accept the d.o.b etc. However, I changed the field to a textbox and gave it the mask ##/##/#### and it all works and no longer crashes my application.

Isn't it always the way when you ask a question you end up finding the answer yourself.

 

[TheAceMan1]

How are ya tag141 . . .

Be aware: changing [blue]Date[/blue] datatype to [blue]Text[/blue] will cause you to loose your date values! (Remember a date is an Integer Value! . . . or in your case . . . was!).

Your headed for much trouble here . . .

See Ya! . . . . . .