BI Publisher (MOSC)

MOSC Banner

eText ConcatenatedInvoiceInfo

edited Jan 22, 2013 3:16AM in BI Publisher (MOSC) 1 commentAnswered
Hi,
I am modifying an eText template.  My requirement is to have a ConcatenatedInvoiceInfo as follows:

DocumentNumber/ReferenceNumber||’,’||DocumentDate||’,’|| DocumentDescription which gives the result as:

1A,2012-08-31,kontaktipõhine uuring 12/2012

But I need the DocumentDate format to be 31-08-2012.  In a normal field i know how to add the format mask, but how can I achive the same in a concatenated field?

Any help?

Thank you in advance.

Senthil

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center