Thanks for the reply but I need to know how many days-hours-minutes there is between 2 date/time ranges: (Example) 10/24/48 -11:56:23 and 12/15/96 - 15:33:55
Did you try? Pg 108 says the SUBTRACT operation 'will' take two TIME values, SUBTRACT, and return a TIME value as the difference.
What is the result of your example?
Yes is does take 2 "TIME" values but will NOT take "DATE" values.
As I said before I need to know the difference(how many days, hours, minutes, seconds, have elapsed) between let's say (10/24/1948 - 11:28:32) and (12/24/2016 - 15:45:53)
I don't have CCW or the Micro820, so im just guessing..
can you take startdate - date(any) to dint and time to dint, combine them and then take stopdate - date(any) to dint and time to dint , combine and finally do the math. Convert dint(any) to date / time?
Just a thought.
You may have to break apart the result twice, once to calc the DATE portion and then again to calc the TIME portion.
If you are lucky, CCW has something similar to UNIX EPOCH datetime handling. See this for a tool to compare your results.
The manual shows support for LINT (long int) that may be needed in place of DINT in my earlier posts. Cell phone screens are too small.
It also mentions something in the ANY_TO_DATE (pg286) about TIME being added to DATE, so maybe there is some hope for this task.