combining a time and a date to one Date/Time value
Hi,
I have two strings, one with a date (tbDate.text) one with a time
(tbTime.Text).
Now I would like to combine both to a new Date.
right now I do this like that:
New Date(DatePart(DateInterval.Year, CDate(tbDate.Text)),
DatePart(DateInterval.Month, CDate(tbDate.Text)), DatePart(DateInterval.Day,
CDate(tbDate.Text)), DatePart(DateInterval.Hour, CDate(tbTime.Text)),
DatePart(DateInterval.Minute, CDate(tbTime.Text)),
DatePart(DateInterval.Second, CDate(tbTime.Text)))
But I think that is kind of to complicated, is their a nicer way to do this?
Thanks Johannes