Date Diff between Created Date and Closing Date

[Alicia83B]

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 function. The minimum argument count for the function is 3. I have never used this function before and have followed what I have seen in other formum examples with no resolution. Can someone direct me on how to correct the error?

Time to Close (Days) = DATEDIFF(MIN(Opportunities[createdtime]), MAX(Opportunities[closingdate], DAY))

Thank you in advance for looking at my post. 

[Greg_Deckler]

@Alicia83B Try:

Time to Close (Days) = ( MAX(Opportunities[closingdate]) - MIN(Opportunities[createdtime]) ) * 1.

Also, you are missing a ) right before ", DAY" and so then have an extra ) at the end.

[Alicia83B]

@Greg_Deckler  Hi Greg, thanks for the reply. This did not work. I have a red swiggly line under the ) before *1

[Greg_Deckler]

@Alicia83B 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 · Accepted solution]

@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.