DateTimeAdd

[Zoe_cross16]

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!

[DataNath · Accepted solution]

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')

[Zoe_cross16]

Ahh yes thank you!