Convert.ToDateTime to particular format

Asked Nov 13 '17 at 13:39

Active Nov 13 '17 at 13:57

Viewed 695 times

I want the dates in dd-MM-yyyy format. I have set it in Global.asax. But it gives me following error when I try to convert date string to DateTime.

An exception of type 'System.FormatException' occurred in mscorlib.dll but was not handled in user code. Additional information: String was not recognized as a valid DateTime.

I don't want to pass the date in string (don't want to use ToString('format')). Please help.

Below is my code in Global.asax.

protected void Application_BeginRequest(object sender, EventArgs e)
    {
        CultureInfo cInfo = (CultureInfo)System.Threading.Thread.CurrentThread.CurrentCulture.Clone();//new CultureInfo("en-IN");
        cInfo.DateTimeFormat.ShortDatePattern = "dd-MM-yyyy";
        cInfo.DateTimeFormat.LongDatePattern = "dd-MM-yyyy HH:mm:ss,fff";
        cInfo.DateTimeFormat.DateSeparator = "-";
        Thread.CurrentThread.CurrentCulture = cInfo;
        Thread.CurrentThread.CurrentUICulture = cInfo;
    }

In Controller:-

public ActionResult Index(string dateParam)
    {
        DateTime? dataObj = dateParam != null ? DateTime.ParseExact(dateParam, "dd-MM-yyyy", System.Globalization.CultureInfo.InvariantCulture, System.Globalization.DateTimeStyles.None) : (DateTime?)null;
       // -- Do something --
        return View();
    }

edited Nov 13 '17 at 13:54

asked Nov 13 '17 at 13:39

DhavalR

1,409
3
29
57

Possibly duplicated https://stackoverflow.com/questions/300841/how-do-you-globally-set-the-date-format-in-asp-net – Edward N Nov 13 '17 at 13:42
Where is the code where you do the actual conversion? – Sefe Nov 13 '17 at 13:42
@Sefe - Please see the edit. – DhavalR Nov 13 '17 at 13:43
This maybe help you: https://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo.defaultthreadcurrentculture(v=VS.110).aspx – Mitat Koyuncu Nov 13 '17 at 13:44
`DateTime dateObj` this is a DateTime object which has no format – EpicKip Nov 13 '17 at 13:47
Are you using a `DateTimePicker` or a standard `TextBox` as an input control? – Tebogo Khanye Nov 13 '17 at 13:48
Your code that sets the culture is in which event handler in Global.asax? If you want it to apply to all requests, you might want to put it in, say, Application_BeginRequest. – Joe Nov 13 '17 at 13:49
@Joe - It's in `Begin_Request` – DhavalR Nov 13 '17 at 13:50
@DhavalR an MCVE would help. – Joe Nov 13 '17 at 13:51
@Joe not everyone is familar with that abbreviation (MCVE = https://stackoverflow.com/help/mcve) – Rand Random Nov 13 '17 at 13:54
@Joe - I have updated my question. Please see the code in `Global.asax` and `Controller`. – DhavalR Nov 13 '17 at 13:55
Why are you passing in the `InvariantCulture`? That's not going to use your culture settings. – juharr Nov 13 '17 at 13:56
1

What is the contents of `dateParam` ? I bet it is not in the format `dd-MM-yyyy`, is it? – Fildor Nov 13 '17 at 14:05
@RandRandom - most people have access to google though. – Joe Nov 13 '17 at 14:29
1

@Joe if those people would know how to use google they wouldnt ask questions :) – Rand Random Nov 13 '17 at 14:49
@Fildor - It is in `dd-MM-yyyy` format. – DhavalR Nov 13 '17 at 15:25
@RandRandom - fair point. Maybe the comment editor should automatically change MCVE to a link to that help page, to help people as lazy as me. – Joe Nov 15 '17 at 20:46

Convert.ToDateTime to particular format

0 Answers0