Add Date to Time

[kennedymr2]

Using VB2008

I have a string #10:00:00#

Need to add todays date to to above to get a datetime eg

"#10/7/2011 10:00:00#"

Is there a simple way of doing this ???

Appreciate some help

regards Kennedymr2

 

[ousoonerjoe]

Test it, but should work:

            Dim DateVal As Date
            DateVal = "10:00:00"
            DateVal = Today & " " & DateVal

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------

 

[kennedymr2]

ousoonerjoe

Thanks very much,worked fine.


Was fiddling around with now() didi not know about 'today'



Regards Kennedymr2