I’m attempting to calculate the difference between two datetimes by day, hour, minute and second. The datetimes are in DATETIME26.6 (ddMMMyyyy:00:00:00.000000) format.
I’d like to result to be day.hour,min,sec
Example:
StartDate EndDate Wanted Result – D.hms
3/24/2021 13:24:49.287000 3/24/2021 13:30:46.886000 0.004
2/4/2021 15:25:58.501000 3/8/2021 13:59:51.848000 31.941
I’ve tried Intck, however seems to be limited to only one increment and looking at the whole number instead of breaking it down by the time increments I need. Any suggestions are welcome! thanks
... View more