Compose Date Function

I

Ilya

Hi:
I am looking for composing the Date as function of Year, Month, Day, Hr,
Min. Each argument as an Integer. So, lookin for MyDate = CustFunct(Year,
Month, Day, Hr, Min).
Thanks in advance.
 
F

fredg

Hi:
I am looking for composing the Date as function of Year, Month, Day, Hr,
Min. Each argument as an Integer. So, lookin for MyDate = CustFunct(Year,
Month, Day, Hr, Min).
Thanks in advance.
Click to expand...

Look up the DateSerial and TimeSerial functions in VBA help.
 
K

Klatuu

You will need to use the DateSerial and TimeSerial functions added together
to get both in the same variable:
dateserial(1943,5,25) + timeserial(18,33,30)
will return:
5/25/1943 6:33:30 PM
 
Top