none
A question about reporting and date format when report exported to Excel

    Question

  • Hello

    Can someone please assist me with the following question. I live in the UK, the regional/keyboard/datetime etc. setting on my management servers and database servers and client PC are all set correctly to UK format. When I run a report in SCOM (2007 R2) to date/time shows correctly on the screen in UK format e.g. DD/MM/YYY. However if I then export to Excel format and open in Excel the format US e.g. MM/DD/YYYY. Therefore I am wondering at what point it goes from UK when viewed on the console to US when exported to Excel.

    Is this a know issues?

    Thanks you

    JoB333x1!

    Saturday, July 27, 2013 3:55 PM

All replies

  • Hi, it's most likely it's on the side of SSRS, is it placed on one of your MS? try to update first (MPs, SSRS,CU)

    SCOM 2012 SP1 CU2 + SQL 2012 SP1 no such issue

    Tuesday, July 30, 2013 8:18 AM