Query to combine a date and a time

[jake7363]

Hi,
I am trying to create a general date field by combinging a date (short date) and time (medium time) field. The fields are named recDate and recTime for the two I am combining, and cmbDateTime for the result field.

When I run the query, the result I receive is an errror stating that it is a data type mismatch.

What am I missing?

Thanks in advance,
Jake

 

[neileg]

There's no such things as a date datatype or a time datatype, just a date/time. So either your fields are both date/time or possibly one or both are text. How you deal with the concatenation depends on this.

 

[jake7363]

re Query to combine a date and a time

Apologies for the lack of clarity. All the fields are set to date/time, but the formats are Short date, Medium time, and General date. Given this information, then how do I set up the cocatenation?

 

[neileg]

Since they are both date/time, the data is actually stored as a number so you just sum them.

cmbDateTime: recDate + recTime

 

[jake7363]

re Query to combine a date and a time

Got it ... made it too difficult for myself..

Thanks