Forum

Power Pivot - Date ...
 
Notifications
Clear all

Power Pivot - Date Table yields year 1899

2 Posts
1 Users
0 Reactions
73 Views
(@aparker70)
Posts: 10
Eminent Member
Topic starter
 

I am selecting a date column in my DATA tab in Power Pivot. From that I selected "Date Table" - New.

The table resulting starts in year 1899. 

The dates are formatted as a date, and the years go from 2014-2019 For now, I've filtered out preceding years.

I don't understand why the year is doing this. I double checked the data.

Any help is appreciated. 

 
Posted : 17/04/2019 12:56 pm
(@aparker70)
Posts: 10
Eminent Member
Topic starter
 

Never mind! I figured it out. 🙂

 
Posted : 17/04/2019 3:15 pm
Share: