2 Replies Latest reply: Dec 30, 2008 4:14 AM by 663759 RSS

    Date format stored as YYYYMMDD but i need DD-MMM-YYYY

      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..?