trouble with days between dates in powerpivot

[wtallen]

I am trying to calculate the number between the date in a column and a specified date such as 6/30/2012. In Excel I am able to just use something like =+Date(2012,06,30)-G2 but in powerpivot pulling from an Access data base, I try to use BetweenDates. I have tried several times and thought something like DatesBetween,Dates,[DtofSvc], Date(2012,06,30)) as a calculated field. Am I way off base?

this is my first post so please forgive and correct any fax pas.

Thanks

 

[scottsen]

Ya, DateBetween is totally not what you think it is for

You should do much like you do in native excel. [DtofSvc] - Date(2012,06,30) should give you the number of days between, though you may have to round or whatever (it will give the floating point)

 

[wtallen]

Thanks but when I try that the formula returns another date such as 12/14/1899.

 

[scottsen]

Ya, that is just showing you a number... formatted as a date. Change the type of that calc column to a number.

 

[wtallen]

OK. Thank you sir!