Hi all,

       I did wrong. In my database table there is a field name RecDate it's datatype is text(MS Access database).

       There are three textboxes first one is for month; it's having 1 to 12 second is for date; its having items 1 to 31 and the third and last one is for year.

I am saving date like "+DropDownlist1.SelectedItem.Text+"/"+DropDownlist2.SelectedItem.Text+"/"+DropDownlist3.SelectedItem.Text+"/

It is ok.

Now when I featching records using query like orderby date. It's not working properly because query reads this date as string. I used this method in many forms. Its very time consuming to change it.

Is there any other method to do it right.

help me out pls. what should I do for this condition. I'll never repete this in future. I came to know for date field ur datatype shpould be always datetime.

Thanks a lot

You can cast it in backend. I mean while retrieving it self.

Am not sure how to that in MsAccess, but I guess it would be similar to Sql. For sql convert refer this

http://www.sqlusa.com/bestpractices/datetimeconversion/

demoninside9:

Is there any other method to do it right.

Start by changing the recDate field to a DateTime, not a text field.

instead of 3 dropdowns, why not use only 1 textbox, an use for example the Ajax Control Toolkit Calender extender:

http://www.asp.net/AJAX/AjaxControlToolkit/Samples/Calendar/Calendar.aspx

and about using dates with Access, read this:

http://www.mikesdotnetting.com/Article/92/MS-Access-Date-and-Time-with-ASP.NET

Yep, always use the DateTime format. It's made for this reason.

For now you could solve your problem by using this in your query's:

"SELECT *, DateSerial ([YearField]; [MonthField]; [DayField]) AS MyDate FROM MyTable WHERE ...blablabla..."

Good luck,

use this,

declare @dtchar nvarchar(20)
set @dtchar='11/29/2009'        //11 - Month,29 - Date and year
select convert(datetime,@dtchar)

O/P is  2009-11-29 00:00:00.000

Hi demoninside9

Another info about the date and time

http://codeincsharp.blogspot.com/2008/05/different-date-format-in-c.html