Forum Discussion
Alicia83B
Helper I
Helper IDate Diff between Created Date and Closing Date
I am trying to calculate the length of time between an opportunity created date and closing date. I am using the below measure, but I get an error "Too few arguments were passed to the DATEDIFF func...
Alicia83B No, forget about the DATEDIFF, you don't need it, use the actual formula I provided. It is a 100% complete formula. Dates are decimal numbers where the integer portion is the number of days since 12/30/1899. So all you have to do is subtract them and multiply by 1. to make sure you return a number instead of a date.
Alicia83BHelper I
Helper IGreg_Deckler Below is what I have for the measure. Still not working.
Time to Close (Days) = DATEDIFF( (MAX('Opportunities'[closingdate]) - MIN('Opportunities'[createdtime]) ) * 1)
Greg_Deckler
Community Champion
Community ChampionAlicia83B No, forget about the DATEDIFF, you don't need it, use the actual formula I provided. It is a 100% complete formula. Dates are decimal numbers where the integer portion is the number of days since 12/30/1899. So all you have to do is subtract them and multiply by 1. to make sure you return a number instead of a date.