BI Report, Business Intelligence Report,, Rich Text Format, RTF

RTF Date Formatting With Example

RTF Date Formatting: well, any report you create, one crucial field type will be of Date Type and depending on the geography of the user, you will be tasked to format the date in specific format. Now the field can be of 2 type: one is coming from the database and other will be the system date (sysdate) to show right up in the report header. This post is to give the syntax and how you can show the date in various formats. For the demonstration purpose, my XML has a tag named ACCT_DATE. Value of the field is 2020-12-13T18:22:59.682+00:00.

One point to remember is that date value should be in Java date format for the syntax to work. My preference is YYYY-MM-DDTHH:Mi:SS. If your date is not in Java supported format, code might not work properly and there are chances that your formatting effort will not bear any fruit i.e. date will get printed as it is available in input XML field.

So below is the code snippet where you can see various options available and in the next image, you can see the corresponding output. For first 6 formats, ACCT_DATE tag is used while last 3 are the examples for system date ( sysdate) manipulation.

RTF Date Formatting Code Snippet

1<?format-date: ACCT_DATE;’DD/MM/YYYY’?>
2<?format-date: ACCT_DATE;’MM/DD/YYYY’?>
3<?format-date: ACCT_DATE;’YYYY/MM/DD’?>
4<?format-date: ACCT_DATE;’SHORT’?>
5<?format-date: ACCT_DATE;’LONG_TIME_TZ’?>
6<?format-date: ACCT_DATE; ‘MEDIUM’?>
7<?format-date:xdoxslt:sysdate_as_xsdformat();’SHORT’?>
8<?format-date:xdoxslt:sysdate_as_xsdformat();’MEDIUM’?>
9<?format-date:xdoxslt:sysdate_as_xsdformat();’LONG’?>
RTF Date Formatting Code syntaxes

Output


And here is how the output looks like for above code syntax

RTF Formatting Output
Date Format Output

As you can see that function sysdate_as_xsdformat() is used to get the system date ( sysdate). But watch out for the timezone of the user. Reason being, with Oracle Fusion Cloud in place, chances of users being in different timezone is considerably high. And that is why timezone is important while printing the date.

Related Posts

RTF Number Formatting With Examples
RTF- Looping Finite Number Of Times
How To Develop an RTF Template

By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports or SQL queries. Try them only when nothing else works.. kind of SOS...
https://www.amazon.in/gp/product/B093CC1CLD?ie=UTF8&tag=oraclebytes-21&camp=3638&linkCode=xm2&creativeASIN=B093CC1CLD

Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.

Reference:
support.oracle.com

Check out the Amazon Deals of the day based on your interests..

How useful was this post?

Click on a star to rate it!

Average rating 5 / 5. Vote count: 1

No votes so far! Be the first to rate this post.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?