Hello,
I would like to take the date portion of one field and combine it with the time portion of another field in a third field in a custom form. I'm familiar with the datevalue() and timevalue() functions, but can't seem to get the syntax right to have the third field display properly. Any help would be greatly appreciated.
Field1 = "9/18/14 7:00am"
Field2 = "10/2/14 12:00pm"
would like Field3 to equal "9/18/14 12:00pm"
Thanks,
Dave M.
I would like to take the date portion of one field and combine it with the time portion of another field in a third field in a custom form. I'm familiar with the datevalue() and timevalue() functions, but can't seem to get the syntax right to have the third field display properly. Any help would be greatly appreciated.
Field1 = "9/18/14 7:00am"
Field2 = "10/2/14 12:00pm"
would like Field3 to equal "9/18/14 12:00pm"
Thanks,
Dave M.