Question date time picker control problem

[chandrubngit]

I’m developing an windows application using vb.net 2003 as front end& ms access 2003 as backend.
I have a column to store date(today’s date).datatype I’m using is text.i.e. using front end I wil add some new records to database,
At that moment “today’s” date wil be stored in the corresponding column as text datatype.

Then in frontend I need to search the database for records between 2 date ranges and display in a datagrid.
To select date ranges I’m using 2 date time picker controls with short date format.
The Resultant recors will not be 100% accurate if I select date as single digit date(i.e. below 9 to 1).
If I select dates 10 & above 10 (2 digit date) , the resultant records wil be accurate.

Pleass suggest me the solution.Thanks in advance.

 

[JohnH]

Pleass suggest me the solution.

Store Date values as Date data type in database. Converting a Date value to string is only meant for display purposes.

 

[chandrubngit]

problem solved

thanks
problem solved