I have two fields, one is
ISSUEDDATE and the other is
ISSUEDTIME. I would like to concatenate fields so that the
ISSUEDDATE is in
m/dd/yyyy hh:mm:ss format.
ISSUEDTIME field is a string and
ISSUEDDATE is a date field and the
ISSUEDDATE isn't consistent. Some of the values read as
m/dd/yyyy 7:00:00 AM while others are
ISSUEDTIME isn't consistent either as some are AM/PM and others are 24 hour time.
How can I accomplish this without adding a field?
I have tried to concatenate the two fields, but it fails. Since there are two time formats, the solution below fails also. I can execute this via selection and field calculate but would like for it to be done in one go.