Intelligent Advisor

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Removing Comma (,) from Year Formatting

Patrick DevineSep 12 2011 — edited Sep 19 2011

Hello,

I'm attempting to generate a text string that corresponds to a given year. However, when I convert to text from the number format, the result includes a comma:

the date's year = Text(ExtractYear(today's date)) -> "2,011"

1. Does anyone know how to prevent the comma in the text attribute, so that I'll get "2011" rather than "2,011"?

2. Similarly, I'd also like to know how to format the decision report so that the number variable (the output of 'ExtractYear') also does not appear with a comma.

Thanks in advance,
- Patrick

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 17 2011

Added on Sep 12 2011

#date, #intelligent-advisor-general-discussion, #opa

3 comments

484 views