Difference between dates
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?
0
Answers
-
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!**2
Categories
- 7.4K All Categories
- 13 Getting Started in the Community
- 151 Beastmode & Analytics
- 1.8K Data Platform & Data Science
- 54 Domo Everywhere
- 2K Charting
- 1K Ideas Exchange
- 905 Connectors
- 239 Workbench
- 343 APIs
- 77 Apps
- 19 Governance & Productivity
- 237 Use Cases & Best Practices
- 50 News
- 473 Onboarding
- 573 日本支部