Date time issue

Peter_1985 2,526

Hi,
I have the code like
                        to_dt_val = tb_valid_to.Text.Trim() + " 12:00:00 AM";
                        cmd4.Parameters.Add("@dt0", SqlDbType.DateTime).Value = DateTime.ParseExact(to_dt_val, to_dt_format, CultureInfo.InvariantCulture);

it is having the time (on the day) shown on the page. But the time part disappears when I put the cursor on the field and leave the field. How to resolve it?

Viorel 112.5K Reputation points

2023-06-28T05:13:55.2666667+00:00

Probably you must adjust the format of the field and change the type of database column. Show details about the field and column.
Peter_1985 2,526 Reputation points

2023-06-28T06:30:48.7966667+00:00

Do you mean the field should be date time field instead on the current ASP page, to have no issue, right?
QiYou-MSFT 4,306 Reputation points Microsoft Vendor

2023-06-28T07:39:58.23+00:00

Hi @Peter_1985

The code you give is SqlCommand's database operation code. I can't reproduce the problem based on the code you gave. If you can give more code (front-end or critical code), I will be better able to help you solve the problem.

Best Regards

Qi You

Peter_1985 2,526

QiYou,

The field is like
                    <asp:TextBox ID="tb_valid_to"
                        width="420px"
                        Enabled="true"
                        Font-Names="標楷體" 
                        Font-Size="13pt" 
                        Font-Bold="true"
                        ForeColor="Black"
                        runat="server" />

Do you think the code below is the reason?
        $(function () {
            $("#tb_valid_to").datepicker({
                autoclose: true,
                todayHighlight: true
            });
        });

AgaveJoe 26,136 Reputation points

2023-06-28T10:50:28.81+00:00
@Peter_1985, I'm pretty sure the datepicker is causing this issue. More importantly, is there a valid reason why you don't simple comment or remove the JavaScript to test if the datepicker is causing the problem?

Perhaps you should find a different widget that fits your needs. I assume you need to time for scheduling something? A date, time, and/or datetime-local input might work better than a text input with a datepicker? Be sure to read the linked documentation because the text format is specific.

<asp:TextBox ID="tb_valid_to" runat="server" type="date"></asp:TextBox>
QiYou-MSFT 4,306 Reputation points Microsoft Vendor

2023-06-29T06:46:13.1433333+00:00

Hi @ Peter_1985

DatePicker is a date picker. I tested it based on the jQuery code you gave and it only shows the date. The cause of your problem should be a datepicker's problem. Is it possible to select a time for your datepicker in your project? Do you mean that your datepicker can select the time, but does not display the time in the textbox after selecting it?

Best Regards

Qi You
Peter_1985 2,526 Reputation points

2023-06-29T07:10:51.3+00:00

QiYou,

I put the cursor to the field and then I put the cursor to the other field but the time part disappears. This is the issue.

How to ensure the date picker is having time included?
QiYou-MSFT 4,306 Reputation points Microsoft Vendor

2023-06-29T09:23:37.6+00:00

Hi @Peter_1985

This website can help you:

Introduction to DateTimePicker

Best Regards

Qi You
Peter_1985 2,526 Reputation points

2023-06-29T09:30:16.4866667+00:00

I will revert further.

<link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.3.0/css/datepicker.css" rel="stylesheet" type="text/css" />
Peter_1985 2,526 Reputation points

2023-06-29T10:13:19.9566667+00:00

I put datetimepicker instead and it seems it is wrong below. How to correct it?

<link href="https://cdnjs.cloudflare.com/ajax/libs/bootstrap-datepicker/1.3.0/css/datetimepicker.css" rel="stylesheet" type="text/css" />
AgaveJoe 26,136 Reputation points

2023-06-29T10:59:07.2733333+00:00

The link QiYou-MSFT shared work for me. Unfortunately, you did not share enough code for any one to figure out what you're doing wrong! Review the documentation to figure out where you made the mistake.

AgaveJoe 26,136

Also, did you at least try the links I provided?

https://developer.mozilla.org/en-US/docs/Web/HTML/Element/input/datetime-local

    <div>
        <asp:TextBox ID="tb_valid_to" runat="server" type="datetime-local"></asp:TextBox>
    </div>
    <div>
        <asp:Button ID="Button1" runat="server" Text="Button" OnClick="Button1_Click" />
    </div>
    <div>
        <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label>
    </div>

    public partial class _default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!Page.IsPostBack)
            {
                tb_valid_to.Text = DateTime.Now.ToString("yyyy-MM-ddTHH:mm");
            }
        }

        protected void Button1_Click(object sender, EventArgs e)
        {

            DateTime dt = new DateTime();
            if (DateTime.TryParseExact(tb_valid_to.Text, "yyyy-MM-ddTHH:mm", CultureInfo.InvariantCulture, DateTimeStyles.None, out dt))
            {
                Label1.Text = dt.ToString();
            }
            else
            {
                Label1.Text = "Invalid date format.  Expected yyyy-MM-ddTHH:mm";
            }  
        }
    }

Capture

QiYou-MSFT 4,306 Reputation points Microsoft Vendor

2023-06-30T06:20:46.7766667+00:00

Hi @Peter_1985

Can you record your question as a gif? The code you provide makes it difficult to determine what the problem is. At the same time, I am not very clear: calling integrated jQuery is generally difficult to implement the datepicker appearance time part, so I would love to see what your problem is. This is difficult to describe in words, but if there are GIFs and other indications, it will help us solve the problem even more. At the same time, is this all you have to the front-end code of this control?

Best Regards

Qi You

1 answer

Francesco Ciurria 0 Reputation points

2023-06-29T10:38:10.89+00:00
It seems like you're encountering an issue where the time part disappears when you interact with the field. This could be due to the way the field is handling the date value.

One possible solution is to modify the code to explicitly set the time part of the DateTime value to ensure it remains consistent. Here's an updated version of your code:

to_dt_val = tb_valid_to.Text.Trim() + " 12:00:00 AM"; DateTime toDateTime = DateTime.ParseExact(to_dt_val, to_dt_format, CultureInfo.InvariantCulture); toDateTime = toDateTime.Date + new TimeSpan(0, 0, 0); // Set the time to midnight (00:00:00) cmd4.Parameters.Add("@dt0", SqlDbType.DateTime).Value = toDateTime;

In the updated code, we extract the date from the toDateTime value using the .Date property and then add a TimeSpan of zero hours, zero minutes, and zero seconds to set the time part to midnight (00:00:00).

By doing this, you ensure that the time component of the DateTime value remains unchanged, even if the field behavior removes it temporarily.
Please sign in to rate this answer.
Peter_1985 2,526 Reputation points

2023-06-30T06:20:11.9266667+00:00

Good. Your way is fine. Is there any "post event" to put the time part to such field tb_valid_to.Text of ASP page?
Sign in to comment