Merge data type fields

Hello,

I would like to take the YYYY-MM-DD from one field and then add the hours and minutes from another field…how can I do?
the hours and minutes are in string format and the field which has the YYYY-MM-DD has also hour and time but I would like to drop them because are wrong,

Thank you

@remba87 can’t you convert them into string first, then concat, and then convert back to datetime?

1 Like

Hi @remba87 ,

Checking in. We have not heard back from you regarding your question. We’d still like to help. If we do not hear back in the next 3 days, we will archive the question.

Regards,
Koushik

2 Likes

Hello, yes, you can archive it…solved it outside QS :slight_smile: