Post reply

Issue with the Date parameter

  • February 28, 2011 at 12:46 am

    #235750

    hi , i do report in SSRS 2008. with the query with the condition of checking the table's date field's value with the date parameter ...

    everything works fine except the place where its getting executed. in preview part.

    The error is,

    Adding a value to a datetime column caused overflow. The statement terminated.

    What may the problem be??

    Kindly help me !!

  • February 28, 2011 at 7:18 am

    #1292298

    Are you using a DATEADD anywhere in your query, or other math on the date field? Look there for a problem and a solution.

  • February 28, 2011 at 11:45 am

    #1292495

    New Commer (2/28/2011)

    hi , i do report in SSRS 2008. with the query with the condition of checking the table's date field's value with the date parameter ...

    everything works fine except the place where its getting executed. in preview part.

    The error is,

    Adding a value to a datetime column caused overflow. The statement terminated.

    What may the problem be??

    Kindly help me !!

    check for "blanks" in your date field.

    MCTS: BI 2008, MCITP: BI 2008
    Stay Thirsty My Friends

  • February 28, 2011 at 9:46 pm

    #1292706

    Daniel Bowlin (2/28/2011)

    Are you using a DATEADD anywhere in your query, or other math on the date field? Look there for a problem and a solution.

    Yes there im using the DateAdd to calculate the last year date and condition it to provide the value from a table..

    What is the solution ??

    PLease give me..

    MostInterestingMan (2/28/2011)

    check for "blanks" in your date field.

    How to check for the "blanks" ?

    Thanks in Advance !

  • March 1, 2011 at 3:35 am

    #1292792

    The error is appearing only when using the DateAdd function.

    So is there any other query to find the date of last year??

    Please any one reply..

  • March 1, 2011 at 11:03 pm

    #1293332

    After refering to the below link,

    http://qa.sqlservercentral.com/Forums/Topic262686-8-1.aspx

    AMIT GUPTA-263376 (3/2/2006)

    hey!!

    it is working fine man.

    select convert(smalldatetime,'18/01/1976',103)

    BUT DATE EARLIER THAN 1900 WILL CAUSE A PROBLEM.!!

    Regards

    AMIT GUPTA

    i got the light. Actually i had given the default date to be 01/01/1753

    aftere changing to 1900 it worked.

Viewing 6 posts - 1 through 5 (of 5 total)

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