none
Excel Handling of Dates

    Question

  • Hi, I've been trying to do some analytics in Excel of genealogical data but have hit the problem of Excel handling dates pre-1900 - a bit of an issue when official records go back to the 1830s in the UK. Annoying, it means I can't get Power Map timelines working.

    Before I switch to trying to do the same thing plug data mining in SS, can you tell me if this has any date handling issues that you know of? For example, can SSAS and SSRS properly handle dates between the 1500s and today?

    Cheers,

    Karl

    Thursday, November 14, 2013 12:19 PM