I am testing a default SP Designer 2010 workflow action called "Find Interval Between Dates" located under the "Utility Actions" category. I need to compare the amount of time passed between the current item's last modified date and the current date.
The use-case is that I need a workflow to calculate "aging" of a list item, so I want to compare Today's date with Last Modified Date and see if that number of days is greater than some given threshold. The actual behavior is that the workflow thinks the threshold is met almost immediately (suggesting the "day" calculation is close to zero).
At first I tried examining the number (it should result in a number, right?) that was calculated by "find interval between dates", and I get a strange value like ".47" even though the interval I was testing should have been about 3 days. Then I tried hours, and this second test was with an items that had been modified only about 5 minutes ago, so I expected a small fraction for "hours", but my test returned "11.23". What is going on here?