Is there a format/display option that I am missing to display a date in the Oracle format of dd-MON-yyyy? So 01/01/2008 or 01012008, or 20080101 (smart dates) would be displayed on a report as 01-JAN-2008. Or do I have to parse it out and put it back together?
Thanks,

Rick,

Oracle Date Functions are found on the Internet!!!

  
select to_char(date_column, ‘DD-MON-YYYY') as whatever, etc...

Tom

Thanks. I did know that it could be done in SQL. I was hoping for a WebFOCUS display format.

Rick,

OK, Sorry about that, thought it was an Oracle/SQL question:

  
DEFINE FILE CAR
NEW_DATE1/A17 = CHGDAT('YYMD', 'DMYYX', '&YYMD', 'A17');
NEW_DATE2/A11 = CTRAN(17,NEW_DATE1,32,45,NEW_DATE2);
END

TABLE FILE CAR
PRINT CAR MODEL NEW_DATE1 NEW_DATE2
 BY COUNTRY
END

I'm sure other ideas/suggestions will come along...

Hope this example helps...

Tom

This message has been edited. Last edited by: Tom Flynn,

Try using DATETRAN with the -T output option. You will need to convert to a DMYY first with HDATE I think.

That worked. You learn something every day. Thanks