>I have 2 datetime fields
>
>The first contains a date only
>
>The second contains a date and time - the date is wrong but the time is correct
>
>How do I add the time portion of field 2 to field 1
>
>field 1 date 28/10/2016 00:00:00 I need this field to be 28/10/2016 14:31:00
>
>field2 date 30/12/1899 14:31:00
>
>How can I do this?

REPLACE field1 WITH field1 + (field2 - TTOD(field2))

Tamar