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

Bee*

Registered User.
Local time
Today, 05:24
Joined
Aug 22, 2007
Messages
12
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! :-)
 
Since Date/Time datatype is really double numbers just add them together.

9 AM is 0.375

eg:

[DateField] + 0.375

JR
 
Muchos gracias!
 

Users who are viewing this thread

Back
Top Bottom