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
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.