In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

DateTimeAdd

Zoe_cross16
7 - Meteor

Hi, I am doing some work on call times and am struggling with a DateTimeAdd function. How are you supposed to add times together? I have one time in the format 00:00:00 and then a format of 00 for seconds which I would like to add to it. Do they need to be specific data types to work?

Thank you!

2 REPLIES 2
DataNath
17 - Castor
17 - Castor

Hey @Zoe_cross16, in order to apply DateTimeAdd(), you need to make the field a dummy DateTime value. I usually just add '1900-01-01' to it. Then you can just apply it and store the output field as a Time like so:

 

DateTimeAdd('1900-01-01 '+[Call_Begin_Time],[Seconds],'seconds')

 

xyz.png

Zoe_cross16
7 - Meteor

Ahh yes thank you! 

Labels
Top Solution Authors