5 Replies Latest reply: Mar 5, 2013 11:32 AM by Srini VEERAVALLI RSS

    changing the datatype of year column

    user9255588
      Hi

      I have created a view in database and used that view in RPD, when I generated a report on that, the values in the year column is showing as 2,007.2,008.2,009.
      I dont want the , in the year column. I want to show as 2007,2008

      When I checked the datatype the datatype for year is DOUBLE. In physical layer I tried to change the datatype to DATE, when i did consistency check I dint get any error. In answers I am getting ODBC error.

      Please let me know how to resolve this problem, thanks for any help.

      Thanks & Regards,
      SR