Creating a general date from a short date and my own time stamp?

[Bee*]

Hello, I need to create a general date field that takes my field [LogDate] and adds 9am to it (i.e 9:00:00), so that it basically shows 9am of whatever date it happens to be for that row, such as '12/03/2011 9:00:00'

I've tried but it only outputs as a string. Is there a function that I can use to put these together?

Thanks!

 

[JANR]

Since Date/Time datatype is really double numbers just add them together.

9 AM is 0.375

eg:

[DateField] + 0.375

JR

 

[Bee*]

Muchos gracias!