I have two date boxes that contain Now(). These fields have the potential difference of a few hours to a few days. Now what I am needing is an input mask for a third field that would show me the difference in time (eg. [Time Closed] - [Time Pulled]). Unfortunately, I do not have an input mask to show a number of days (eg. 2Days 21:42 ) or even a larger hours (eg. 86:33 ).
Thanks in advance
This is the DateDiff function, this particular statement will show you the number days between the two dates. You can show weeks, hours, or seconds by changing the "d" to other things like "ww" for week. You can look in the help for other constants.