JIRA MCF : Converting a Date into Text

[Marc Jason Mutuc]

I'm using the Calulated Text field to get the Date from another Date field. The purpose of this is to have the "Date" and other "Non-Date" details bunched up together.

Currenty using this one:

 <!-- @@Formula:

if (issue.get("Date Opened") == null) return null;

return issue.get("Date Opened").toString()

-->

The result is 2017-09-13 00:00:00.0

But the desired result is 13/Sep/17

[David Fischer]

You can use Java's format() method of the Date class on the result of issue.get() to format the date to your requirements. 

[Marc Jason Mutuc]

Tried doing this:

<!-- @@Formula:

if (issue.get("customfield_14306") == null) return null;

return SimpleDateFormat("dd/MMM/yy").format(issue.get("customfield_14306"))

-->

But it did not work.

[David Fischer]

You need to instantiate the SimpleDateFormat class, specify its FQN (or import it), and also you're missing a trailing semicolon:

<!-- @@Formula:

if (issue.get("customfield_14306") == null) return null;

return new java.text.SimpleDateFormat("dd/MMM/yy").format(issue.get("customfield_14306"));

-->

[Marc Jason Mutuc]

Thanks @David Fischer!!! It's working now!