SOLVED
DateTimeAdd
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Zoe_cross16
7 - Meteor
‎07-10-2024
08:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
Labels:
- Labels:
- Date Time
2 REPLIES 2
17 - Castor
‎07-10-2024
09:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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')
‎07-11-2024
12:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ahh yes thank you!
