Compose Date Function

[Guest]

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.

 

[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.

Look up the DateSerial and TimeSerial functions in VBA help.

 

[Guest]

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