We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Problems making a DateTime

Timothy_Leber
7 - Meteor

I am trying to combine a date and a time to make a DateTime.  Everything I do ends up with the time being set to all zeros.

 

I have the time as a string in the data, but it is not in the proper format.  So instead of 02:20 I have '220'.  I have it fixed to the correct time format.

 

My Google skills are letting me down on this one.  I am attaching a sample file of my data.

 

Thanks

2 REPLIES 2
michelle_mathews
Alteryx Alumni (Retired)

Hi @Timothy_Leber , you can use the DateTime tool to convert your time columns to the proper time format - see screenshot attached. Then you can use a formula to join that with your date field ([date]+" " +[time]) and mark it as a datetime type. 

 

Capture.PNG

Timothy_Leber
7 - Meteor

I already had the time thing figured out, but figured I was missing something simple on the DateTime conversion.

Labels
Top Solution Authors