3 Replies Latest reply: Feb 11, 2013 7:11 AM by Srini VEERAVALLI RSS

    Column issue


      We have column called ROD .Which contains the Year/Month and datatype is varchar.





      I convert data type as date for splitting the Year and month as separate column.

      But getting following

      A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 46044] Cannot convert string (2011-01) to date data. (HY000)

      How to convert and how to split into Year,Month Columns.

      Kindly let me know.
        • 1. Re: Column issue
          Srini VEERAVALLI
          Try this

          It would be nice to prefix 01 and then convert this to date.

          Above code return the output dd/mm/yyyy, you might need to cast it to date.

          If helps pls mark

          Edited by: Srini VEERAVALLI on Feb 11, 2013 6:33 AM
          • 2. Re: Column issue
            Thank for reply..
            I have to do in RPD or answers.
            Can you please elaborate your explanation .
            • 3. Re: Column issue
              Srini VEERAVALLI
              Code works in both, Answers or RPD. I would suggest to do in Answers once you are good with output then put it in rpd.

              Pull column ROD in Criteria tab->fx use the given code and make sure you use complete column at ROD which is TableName.columnName.

              In rpd you have to use the same code and ROD pointing to physical column in the expression.

              Let me know for issues.

              Edited by: Srini VEERAVALLI on Feb 11, 2013 7:09 AM