community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

DateTime Tool - Cannot get into the right format

Meteoroid

Nothing is more aggrevating than spending 4+ hours on something that "should" be simple... Your help is greatly appreciated!

 

I have a spreadsheet with 2 feilds

  • QC_COMPLETEDDATE
  • NEW_QC_COMPLETEDDATE

They are the same but just formatted differently.  I need to get this data loaded into an oracle table.  I cannot for the life of me get the data to output in either a 24 hour date/time format or a 12hour with AM/PM noted.

 

Any help would be GREATLY appreciate!  I've also tried the datetimeformat in the formula tool with no luck.

 

Untitled.jpg

Bolide

Hey @Tmy8ster,

 

I just helped someone with a similar problem a few days ago. I slightly modified that workflow to fit your ask. Let me know if you have any questions.

date formatting.PNG

Alteryx Certified Partner

Hey Tmy8ster,

 

Try this,

 

Capture.PNG

Highlighted
Alteryx
Alteryx

Hey @Tmy8ster,

 

Try using this format as the incoming string field. I was able to get it to work on a small sample of your data. 

 

%d-%b-yyyy %I:%M%p

 

 

Meteoroid

You're the man!!!!!! Cannot thank you enough for the fast reply and a working solution!  Thank you, THANK YOU!!!

Alteryx Certified Partner

Ah, I was trying to find out how you can automatically account for the 12 hour clock. Nice one @NicholasM 

Labels