none
Report Builder 3.0 - Problem with date parameter

    Question

  • Hey there,

    Here´s my question to my DataSet:
    call sp_agent_detail ('2013-10-21 00:00:00', '2013-10-22 00:00:00', 0, NULL, NULL, NULL, NULL, NULL )

    But instead of changing the dates in the question each time I´d like to add parameters instead.
    But every single time I try this I´m getting the following error:

    "ERROR [22008] [Informix][Informix ODBC Driver][Informix]Non-numeric character in datetime or interval."

    Heres my question with the parameters:
    call sp_agent_detail ('@FromDate', '@ToDate', 0, NULL, NULL, NULL, NULL, NULL )

    And when I press RUN I type the date/time in with the same format as stated in the first question.

    Thanks in advance!


    Friday, October 25, 2013 8:00 AM

Answers