Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Convert strings containing date time values with AM / PM indicators to Datetime value?

Steve3
5 - Atom
‎07-12-2019 09:36 AM

I have delimited text files containing datetime strings such as '6/3/2019 4:13:00 AM' or '6/3/2019 4:13:00 PM' or '10/03/2019 11:13:05 PM'.

There doesn't seem to be an input format for dealing with 'AM / PM' times.

How have others handled this situation?

Labels:
Reply

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
Steve3
5 - Atom
‎07-12-2019 10:08 AM

I figured it out and thought I would post the format in case any other newbies have the same issue.

  1. Use the DateTime tool for each date string to be converted.
  2. Enter a New Column name different from the field/column being converted.
  3. Enter the following Custom format %m/%d/%Y %I:%M:%S %p 
  4. Use the Select tool to uncheck the original datetime string.
  5. Rename the new datetime field back to the original if desired.
  6. Move the new field if needed.

 

 

Reply
Copilot AMA
Live Office Hours
Labels
Top Solution Authors
View All