This content has been marked as final. Show 2 replies
Hi Vinay,1 person found this helpful
In OC/RDC all the responses to questions will be stored in the same table irrespective of their data types. that is a varchar2 datatype field.
The datatype and length for a question you selected during DB setup will be applicable to the front end only. a univariate disc will fire if any data type / lenght mismatch.
so when you take the dataset from OC it will be in YYYYMMDD format. I believe there is a possibility to overcome this with view definitions / view templates.
By modifying the view template you can get it.. give a try
You can get the date field by writing SQL Macro.