Combining date and times

[croydon]

What is the best way to set the date and time in a date field? I am writing a small program that creates appointment slots for certain times within certain dates. I know the dates and start times but can't think of a way of combining these without using a string, as follows:

dteDate = #1/6/2005#
dteTime = "08:00"
strDate = CStr(dteDate) & " " & CStr(dteTime)
dteNewDate = (strDate)

I'm sure there must be a better way. Any suggestions appreciated. Thanks.

 

[Som76]

Hi try this
dteNewDate = dteDate + dteTime
Regards

 

[croydon]

So simple!

Som76, thanks very much.