unable to convert to datetime

Question

2.00/5 (1 vote)

See more:

i trying to get the datetime from client, the code below able to run is run at localhost, but error message "String was not recognized as a valid DateTime." after i upload to server.

javascript:

JavaScript

function checkTime(i) {
            if (i < 10) {
                i = "0" + i;
            }
            return i;
        }

        function getClientDT() {
            var today = new Date();
            var year = today.getFullYear();
            var month = today.getMonth() + 1;
            var date = today.getDate();
            var h = today.getHours();
            var m = today.getMinutes();
            var s = today.getSeconds();
            var ampm = h >= 12 ? 'pm' : 'am';

            month = checkTime(month);
            date = checkTime(date);
            //h = checkTime(h);
            h = h % 12;
            h = h ? h : 12;


            m = checkTime(m);
            s = checkTime(s);

            document.getElementById('<%= hfClientDT.ClientID %>').value = date + "/" + month + "/" + year + " " + h + ":" + m + ":" + s + " " +ampm;

ASP.NET

<asp:Button ID="btnSubmit" runat="server" CssClass="login" OnClientClick="getClientDT()" OnClick="btnSubmit_Click" Text="Sign In" />
       <asp:HiddenField runat="server" ID="hfClientDT" />

c#

C#

protected void btnSubmit_Click(object sender, EventArgs e)
   {
       string s_DT = this.hfClientDT.Value;
       Response.Write(Convert.ToDateTime(s_DT));
   }

the result from my localhost is: dd/MM/yyyy hh:mm:ss tt

any advice?

Posted 11-Dec-13 16:28pm

melvintcs

Updated 11-Dec-13 16:49pm

v2

Add a Solution

3 solutions

Solution 1

What default time format is your computer set to?
You can always use DateTime.TryParse to figure out if the string is in a valid format or not.

Posted 11-Dec-13 16:34pm

Abhinav S

Comments

melvintcs 11-Dec-13 22:43pm

tryParse return invalid. my PC is set to "dd MMM, yyyy hh:mm:ss tt" . do you mean i need to set the format same as my PC? this could be a big problem because not every user visit my webpage using the same datetime format.

Abhinav S 12-Dec-13 0:56am

You need to provide culture in your format.

Solution 3

Try adding the following code into the Global.asax.cs file and test by re-starting your web app:

C#

using System.Globalization;
using System.Threading;

...

void Application_BeginRequest(object sender, EventArgs e)
{
    CultureInfo culture = (CultureInfo) Thread.CurrentThread.CurrentCulture.Clone();
    culture.DateTimeFormat.ShortDatePattern = "dd/MM/yyyy";
    culture.DateTimeFormat.LongDatePattern = "dd/MM/yyyy";
    culture.DateTimeFormat.ShortTimePattern = "hh:mm:ss tt";
    culture.DateTimeFormat.LongTimePattern = "hh:mm:ss tt";
    Thread.CurrentThread.CurrentCulture = culture;
}

Posted 11-Dec-13 18:06pm

Peter Leow

Updated 11-Dec-13 18:07pm

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

♥…ЯҠ…♥ · Accepted Answer · 2013-12-11T17:36:00

Hi Melberry,

I think you machine datetime culture info is not matched with your client datetime culture info so
Try to use cultureinfo class for your requirement to globally validate the datetime in your code.

You may refer these sites for startup and according to that change it and you will find your solution

Link1[^]
Link2[^]
Hope this helps you a bit.

Regards,
RK