Using Cubevalue to pull transactions by date RRS feed

  • General discussion

  • Hi,

    I have a sheet where transactions are entered daily.  The date is entered in "MM/DD/YYYY" format.  I have separate tabs where I am using Cubevalue formulas to query the data by date and report/do analysis.  I've noticed Powerpivot is very picky with the formatting of dates.  If I type in a date and point the cubevalue formula to it, it won't pull anything..but if I paste the date exactly from a powerpivot table, it will pull.  The dates appear exactly the same and in the same format.

    Has anyone run into something like this?

    Thursday, May 9, 2013 2:23 PM

All replies