PAC Control calculate the total number of days

[Edmund]

How can I use PAC Control to calculate the total number of days from the start date to the end date?

[philip]

Simplest would be to leverage the DateTimeToNtpTimestamp() built-in commands - put the start date into a NTP int64 and the end date as well, then get the difference and divide by the constant needed to get to days (371,085,174,374,400i64?).

Lot’s of ideas, gotchas and info in this old thread:

Calculate elapsed time (or countdown to future time)

Hi All, Recently had a request for some sample code to: calculate the duration time between two date/times, for example, time between: March 3, 2013 11:50 and March 4, 2013 10:45. That didn’t sound too hard, but ended up taking me longer than I thought. I wonder if others might have a more elegant solution than mine. The method I used involved: calculating each date/time in terms of seconds since 0, subtracting one from the other, then building the result in human-readable form (leverag…

[Edmund]

Hi Philip, Thanks.
So, use the DateTimeToNtpTimestamp and set 0 = day of the week , 0 = hours, 0 = minutes, 0 = seconds, 0 = milliseconds to get the total days. It’s right?

[philip]

Sounds right - you will need to test it of course.