ansaurus

Question

Answer 1

+1 A:

try this

DateTime.ParseExact("12-12-2010", "MM-dd-yyyy", System.Globalization.CultureInfo.InvariantCulture)

Take care of date format string casing. "dd" can be different from "DD"

Marcelo de Aguiar 2010-07-26 19:25:16

@Marcelo de Aguiar the input wll be from textbox :(

Nagaraj Tantri 2010-07-27 06:57:52

@Marcelo de Aguiar the format also didnt work... it still says, that "MM-dd-YYYY" is not a valid datetime :(

Nagaraj Tantri 2010-07-27 11:08:03

Answer 2

A:

As mentioned above, date format string is case sensitive.

However, are you sure you want to use DateTime.ParseExact as opposed to DateTime.Parse?

bryanjonker 2010-07-26 19:28:02

@bryanjonker am asking the user to input (dd-mm-yyyy) but sql stores it as (MM-DD-YYYY) so i used it.. i guess then the case sensitive part i will have to give a look

Nagaraj Tantri 2010-07-27 06:58:29

Answer 3

+1 A:

It looks like you mixed up DD and MM. Try below:

DateTime dt = DateTime.ParseExact(TextBox10.Text,"dd-MM-yyyy",CultureInfo.InvariantCulture);

Notice that I changed "DD" to "dd"!

UPDATE:

Ok, so I changed "YYYY" to "yyyy" and ran the code below and it parsed sucessfully:

DateTime dt = DateTime.ParseExact("28-01-2010", "dd-MM-yyyy", provider);

If your users really are passing in dates in the format "dd-MM-yyyy" this should work for you. Keep in mind that the second string has nothing to do with whatever format you are storing in your database. It only has to do with the format of the first string argument in ParseExact. HTH.

Abe Miessler 2010-07-26 19:29:32

i am asking the user to input (dd-mm-yyyy) but sql stores it as (MM-DD-YYYY)so i used it.. i guess then the case sensitive part i will have to give a look

Nagaraj Tantri 2010-07-27 06:57:19

Hey Nagaraj, read my update. I still think this is an issue with how users are inputing dates and the format you expect them to be in when you parse.

Abe Miessler 2010-07-27 15:03:00

also, note that dd means the following format: 28, 10, 01 etc. Pay special attention to the "01" example. It expects a two digit day, even for 1-9... Same goes for month.

Abe Miessler 2010-07-27 15:04:56

@Abe , but then if you say my second string does not matter, which i cannot go for textbox.text in the first parameter?

Nagaraj Tantri 2010-07-27 17:12:01

I'm not saying the second string doesn't matter. In fact i'm saying that string is the cause of all your problems. It's all that matters! I don't understand what you mean by, "which i cannot go for textbox.text in the first parameter?" Can you please clarify?

Abe Miessler 2010-07-27 17:31:54

By textBox.text i mean, i have taken input from user through a textbox and since in India we follow dd-mm-yyyy most of the time, i thought ill ask user to enter through textbox then change it to DateTime which is in SQL MM-DD-YYYY...and yeah "yyyy" helps but it then does not parse it too MM-DD-YYYY and throws an exception saying its not according to gorgiean calander... :(

Nagaraj Tantri 2010-07-27 17:36:10

I think there is some confusion here. The bottom line is that if your users are entering info in the dd-MM-yyyy format you will be able to parse that into a DateTime using the method i described. I don't know what you are doing after that but you should AT LEAST be able to parse it into a DateTime. Do you have an IM account I could talk to you on to try and explain?

Abe Miessler 2010-07-27 17:49:56

@abe i am still new to .net with SQL, I am doing this project as a summer course but getting stuck in many things.. still learning process.. my username in gtalk is nagarajtantri

Nagaraj Tantri 2010-07-27 18:09:47

ansaurus

tags:

views:

answers:

DateTime.ParseExact format error

related questions