Hi All, I have date field it is in MM/DD/YYYY HH:MS;SS AM/PM format , I want to modify this field in format of DD-MON-YYYY . I tried with to_char(Date,‘DD-MON-YYYY’) , it is giving error . If it works also when I run the report I cant put filter on dates because this is character type . Can some …

Problem with Date format

system November 10, 2009, 4:29pm 2

Just format the object at universe level - it’s a menu option in Designer.

Or see this topic:

Debbie

Debbie (BOB member since 2005-03-01)