I have problem, when i enter date as 23-aug-2008 in the forms (RDC or OC data entry) tried checking this in the view builder and data looks like this '20080823' but the SAS dataset date format should be 23-AUG-2008 this right?? i dont know y this is happening... i created the date question as DATE type and format as DMY in oc..(moreover the oracle stores the date as DD-MON-YY format but y is it storing this way or shows me in view builder)
I changed the date format type at DCM level .. to be STANDARD ~~ what can be reason? and the solution?
Could anyone help me plz..?
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