Converting 12hr Time to 24

More
11 years 2 weeks ago #5568 by Matt
Hello

I have 2 columns coming in, both string, one is date formatted mm/dd/yyyy, the second HH:MM AM.
I need to combine the 2 columns and convert them to date/time format mm/dd/yyyy HH24:MM.

How can I do that?

Matt

Please Log in or Create an account to join the conversation.

More
11 years 2 weeks ago #5573 by admin
Join fields together using Joiner than use Reformat date function

Peter

Mike
ETL Architect

Please Log in or Create an account to join the conversation.