Date Formats from SQL Server in PP 11.0.1750.32 RRS feed

  • Question

  • I have been using the previous release version of PP quite successfully to pull date fields from SQL Server, then pivot them into Excel. The date fields were correctly translated into dates in Excel.

    Having upgraded to PP 11.0.1750.32, I find that when I update my PP source data in Excel to the new version, my date fields are now rendered in Excel as text in the format 'm/d/yyyy'. I am in the UK and my default locale date format is 'dd/mm/yyyy''.

    Why has this changed, and is there any way I can get the dates to render as dates in Excel rather than text?

    Many thanks


    Thursday, January 12, 2012 9:52 AM