Difference between dates

louiswatson
louiswatson ⚪️
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 Indiana 🥷

    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