Getting end of day from databox entered variable

[dougancil]

I have a web page that has a text box where customers can enter a date/time which is stored as a variable (@scheddate) which then I need to calculate the end of the day no matter what time they enter there. Is there a simple way to do that?

Thank you

Doug

[Rabbit]

Unless you define the end of the day as a fluctuating number depending on other factors, there's no need to calculate the end of the day. The end of the day is always the same time.

[dougancil]

Rabbit,

Specifically, here's what I'm doing:

Try
            If DateTime.TryParse(dateTextBox.Text, myDate) Then
                'Conversion was successful, the data is now in myDate
                newDate = myDate.AddDays(1)
            Else
                errorlabel.Text = "Invalid Date"
            End If
 

and what I don't know how to do is to store the newdate value as a variable and pass that to my sql table. I don't have a control for this value on my page, so I don't know how to add it.

[Rabbit]

Well, then put a control on the form, bind it to the field in the table, and set the value of that.

[dougancil]

Rabbit, I don't want the user to have to enter anything other than the start time, based on that, I want to calculate what the end of the day is, store that as a variable and pass that to my sql server. Even though the end of the day is always 11:59:59, since I don't know the time that the user will be entering as the start time, I have no way to calculate that. Which is what I'm trying to do.

[Rabbit]

They don't have to enter anything. You're putting the control on there so that you can bind it to the table and set the value in your code. It doesn't even have to be visible to the user.