Forum Discussion
Helper IDate Diff between Created Date and Closing Date
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.
Helper IGreg_Deckler Hi Greg, thanks for the reply. This did not work. I have a red swiggly line under the ) before *1
Community ChampionAlicia83B Did you miss the leading ( ? Also, probably need single quotes around your table names:
Time to Close (Days) = ( MAX('Opportunities'[closingdate]) - MIN('Opportunities'[createdtime]) ) * 1.
- Alicia83B
Greg_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
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.