Date and Date/Time - Sneaky Data Types!

Here's a quick tip, one that I think we'll all need sooner or later.

When I got back from last week's amazing consulting/training trip, the team let me know that we had a problem. An existing PowerPivot model, one that had been working just fine for a long time, had stopped working when we refreshed the model with the latest data: