locked
Why Date in Table changed when after Table linked in PowerPivot RRS feed

  • Question

  • Hi,

    I don't know why the date in my table suddenly changed when linked in PowerPivot Table. See below screenshot.

    Date issued : 03-April-13 (PowerPivot changed to 04-Marl-13)

    How to fix this?

    Thanks,

    Edward

    Tuesday, May 10, 2016 10:51 AM

Answers

  • Hi Olaf,

    The Data Type is "Date", PowerPivot Language Set "Match Excel Language (English US), OS Regional Setting "English US". I don't know what else to do!!! :(

    • Marked as answer by Mielkew Wednesday, May 11, 2016 11:29 AM
    Tuesday, May 10, 2016 11:51 AM

All replies

  • Hello Edward,

    Looks like a mix up with en-US and en-GB format of the dates: PowerPivot interpret date 3/4/2013 as 4/3/2013 and 1/5 and 5/1. In Excel is the column formatted as data type "date"? Do you have different regional settings in PowerPivot then on Windows OS? You can check & change it under tab "PowerPivot" => "Settings" => "Language"; I guess they are different.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, May 10, 2016 11:29 AM
  • Hi Olaf,

    The Data Type is "Date", PowerPivot Language Set "Match Excel Language (English US), OS Regional Setting "English US". I don't know what else to do!!! :(

    • Marked as answer by Mielkew Wednesday, May 11, 2016 11:29 AM
    Tuesday, May 10, 2016 11:51 AM