Project and Portfolio Management Practitioners Forum
cancel

change format to dd-mm-yy

Highlighted
rizKL
New Member.

change format to dd-mm-yy

Hi,

I'm very new in this system.
Need anyone to help me to change my report "target date" insted of display as October 30,2010 to 30-Oct-10.

Many thanks

1 REPLY
Jason Nichols K
Acclaimed Contributor.

Re: change format to dd-mm-yy

If you have control over the SQL in the report, use the TO_DATE and TO_CHAR command, e.g. SELECT TO_CHAR((TO_DATE(SUBSTR(PARAMETERXX, 1, 9), 'DD-Mon-YY'), 'Month DD, YYYY') FROM KCRT_REQUEST_DETAILS WHERE ... Since dates are stored as text in the table, you need to convert it to a DATE type first, then you can reformat it however you need.