Hey everyone,
Basically everything im trying to do is summed up in the subject line. I have a "DatePicker" control on my site, that when a date is selected, is displayed in the textbox as "April 12, 2012" or whatever the subsequent date may be. However, when I save this into my DB in a "Date" field, it saves in the format of "2012-04-12" which is fine with me, I just need to know the function in order to compare the DB value to a value in the DateSelector textbox. This is for a system I am building in case a user wants to "edit" a previously stored record, in case they change the subsequent date.

I have tried using

but get the error of;
Conversion from string "YYYY-00-16" to type 'Date' is not valid.

When the date selected was April, 16 2012

Any help is much appreciated.
Thank you for your time,

6 Years
Discussion Span
Last Post by jijo cleetus

hi Nick ...

Try this..........

   DateTime s = DateTime.Now; //Declare date time variable
   String S_Date = s.ToString("MM/dd/yyyy HH:mm:ss tt", System.Globalization.CultureInfo.InvariantCulture); //Convert to desired format
   System.Threading.Thread.CurrentThread.CurrentCulture = new System.Globalization.CultureInfo("en-US"); //dd/MM/yyyy
   s = DateTime.Parse(sate); //assign back to datetime variable...

   once you have converted date time to this format you can directly insert to database............
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.