locked
Import 1/1/1900 to Excel worksheet with "Output Static" gives 2/1/1900 RRS feed

  • Question

  • Hello,

    When i do an "output static" import to an Excel Worksheet in Dax Studio of date 1/1/1900 (from MS SQL Server) i get 2/1/1900...

    Any ideas? Thanks.

    Thursday, October 20, 2016 11:57 AM

Answers

  • Hello,

    Then I guess one part of the process handles the date as numeric value.

    In MS Excel the numeric 1 represents the date value 1/1/1900, while in SQL Server it is 2/1/1900 (0 = 1/1/1900)

    select convert(datetime, 1)


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, October 31, 2016 3:06 PM

All replies

  • Any suggestions for dJan?

    Thanks!


    Ed Price, Azure Development Customer Program Manager (Blog, Small Basic, Wiki Ninjas, Wiki)

    Answer an interesting question? Create a wiki article about it!

    Sunday, October 30, 2016 10:09 AM
  • Hi dJan37,

    Generally, it works fine, please check your date in MS SQL Server using T-SQL if it is fine, for example, select A.Date from table A.

    Then please verify there is not calculation in DAX Studio. For Excel only, the output model includes Linked and Static. This output static option simply executes the DAX query and copies the results into the specified sheet in the active Excel worksheet. This is just a static copy of the data which cannot be refreshed. (unlike the Linked output option).

    Best Regards,
    Angelia

    Monday, October 31, 2016 9:18 AM
  • Hello,

    Then I guess one part of the process handles the date as numeric value.

    In MS Excel the numeric 1 represents the date value 1/1/1900, while in SQL Server it is 2/1/1900 (0 = 1/1/1900)

    select convert(datetime, 1)


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Monday, October 31, 2016 3:06 PM