Post reply

the conversion of a char data type to a datetime data type resulted in a out-of-range datetime value

  • February 5, 2010 at 4:56 am

    #220270

    Hi There,

    I am getting the following error when I am calling a view from Excel.

    When I run the view directly from Enterprise Manager - I get the results returened to me fine.

    It is when I try and call the view from Excel when I get the fol.owing error -

    the conversion of a char data type to a datetime data type resulted in a out-of-range datetime value

    Any idea why this would happen, if it pulls back data ok in Sql but not in Excel?

  • February 5, 2010 at 8:10 am

    #1114467

    Are you specifying a date in your WHERE clause? If so, then the format you are passing might not match the format for your default language - e.g. if your default language is British English and you try passing a date in the format 'MM/DD/YYYY' you will get this error (or worse still, you'll get incorrect results if the day is between 1 and 12).

    Hope this helps.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply