HI Team:

Problem:  
The date from an external data base is formatted


YYYY-MM-DD HH:MM:SS and to import as a field update into Zoho it needs to be  MM-DD-YYYY HH:MM:SS .

I have used excel to delimited the Date from the Time Stamp and reversed date format to MM-DD-YYYY  (as needed), but when I attempt to concatenate the Date and Time Stamp back together I get the "Text" Format and unable to convert back to Date/Time Format.

Thank you,

Sara