Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
Month to Print in Capital Letters
PittPolack
Hi - I am formatting the dates in my report as MMM yy. I am getting Mar 12, but I want MAR 12. Any ideas on how to capitolize month?
Thanks!
Find more posts tagged with
Comments
johnw
If you are using the Format Date under the property editor, you cant.<br />
<br />
But you can use the following expression:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>var formater = new Packages.java.text.SimpleDateFormat("MMM yy");
formater.format(row["ORDERDATE"]).toUpperCase();</pre>
<br />
See the attached example.
PittPolack
Thank you for your response. We will give that a try.