Depending on the format.. You may want to try putting the date surrounded by # Like this ACCESS = SELECT * FROM tableName where Column > #8/15/05# SQL = SELECT * FROM tableName where Column > '8/15/05' Hope that helps.. If it makes you feel better. this thing drove me up the wall when I first started ASP.Net. Ali Husain -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of hemant Sent: Thursday, September 15, 2005 9:24 PM To: [email protected] Subject: [AspNetAnyQuestionIsOk] Date Format from string to datetime Sir This is my first email to this group ....... Just a Begginer in ASP.Net .I have a problem with datetime format What i have done is taken a date from popup calender and changed it to string format now i have the date in string format and my database date has datetime format so how could i change this string date format again to datetime format ( 1 more thing is i am posting this date format from 1 page to another and i am building my sql statement on that page ) any help regarding this would be welcomed .......... Thanks in advance!!!!!!!!!!!!!!!!
_____ YAHOO! GROUPS LINKS * Visit your group "AspNetAnyQuestionIsOk <http://groups.yahoo.com/group/AspNetAnyQuestionIsOk> " on the web. * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED] cribe> * Your use of Yahoo! Groups is subject to the Yahoo! <http://docs.yahoo.com/info/terms/> Terms of Service. _____ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/A77XvD/vlQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
