Thanks Dan.
>Hi Terry.
>
>You can just use the DATETIME() function -
>
>
>dDate = DATE(2003, 02, 11)
>tDatetime = DATETIME(YEAR(dDate), MONTH(dDate), DAY(dDate), 23, 59, 59)
>
>
>HTH
>
>Dan
>
>>Hello,
>>
>>How do you concatenate a date field and a time field so that you end up with a DATETIME()? Given a date, 02/11/2003, I want to convert it to a DATETIME() field with the time of 23:59:59.
Thanks,
TFISHER