Powerpivot and Dates

[trisoldee]

Hello,

I have a powerpivot that I set up with one of the tables being a date table with text formulas like text(a1,'mmm'), text(a1,'yyyy') and also a column to show if the date is past or future. The issue I'm suddenly having is that when I refresh the linked data table I'm getting an error that tells me

the data types are incompatible. Cannot Convert Value "5/30/2015" of type Text to Number.... Type Mismatch.

When I go to all of the tables, everything is in fact set as a date value. I've gone into the data model and checked the data there and everything is also the same. I read http://www.powerpivotpro.com/2011/02...ky-data-types/ which states something along the lines that time stamps could be causing the issue. The data model does show time stamps but they all show 5/30/2015 12:00:00 AM, the 12:00:00 AM is the same in every single cell. The article also said something about creating a "clean calc" column, I'm guessing that is what I will probably have to do but I was curious if anyone knew of something else that could be causing this/another way to fix it.

Thank you.

[trisoldee]

I dropped in another column to strip out the time stamp and that did it. Just in case anyone else runs into this I guess that seems to be the best way to go outside of SQL.