I’m sorry if the title is a little hard to follow; I’ll do my best to explain better:
I’ve got two fields, a DATE field in the DATE format, i.e.: “Dec 27, 2019 12:00:00 AM”, and a TIME field in a STRING format, i.e.: “17:01:00” which is the time of day on the aforementioned date. I need to essentially replace the “12:00:00AM in the former with the time from the latter, i.e.: “Dec 27, 2019 17:01:00”.
I thought maybe CONCAT() wrapped in a FORMATDATE(), but when I concatenate the two fields, I get this: “Fri Dec 27 00:00:00 CST 201917:01:00”, and any attempt to FORMATDATE() that value gives me the “function argument not compatible: Is ‘STRING’ but expected ‘DATE’” error message. Can anyone offer any ideas on how I might do this?
Please sign in to leave a comment.