Difference between dates

louiswatson
louiswatson Member
in Charting

I'm looking to work out the average time in days from 'Instructed' to 'Completed' (both dates), I'm using DateDiff but the returned value is -151 for some reason. Is there something I am doing wrong with this formula?

Answers

  • GrantSmith
    GrantSmith Coach

    Likely you're swapping the order of the parameters. If you reverse the order it should get you a positive number. The order is backwards where it expects the end date as the first parameter and the start date as the second parameter.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories