nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Date Type Script Field returning '$datePickerFormatter.format($value)'

Jake Jollimore

I'm using ScriptRunner to create custom Script Fields, and my most recent one is to display the date an issue was last assigned in the format 'Aug 20, 2018'. That field is called 'Date Assigned'

Currently, the field is set as a Text Field type, but I want to be able to use filters/functions on that field like 'Date Assigned <= 10d' in my reports.

However, when I change the field type to 'Date Time Picker' or 'Absolute Date Time', I always get the following output:

'$datePickerFormatter.format($value)' or 'Invalid Date'

What am I doing wrong? P.S. If keeping the format of 'Aug 20, 2018' is going to prohibit me from changing it to a Date type field, I can use a different format.

Here's the script:

import com.atlassian.jira.issue.*
import com.atlassian.core.util.DateUtils 
import com.atlassian.jira.component.ComponentAccessor
import com.atlassian.jira.issue.history.ChangeItemBean
import com.atlassian.jira.issue.changehistory.ChangeHistoryManager

ChangeHistoryManager changeHistoryManager = ComponentAccessor.getChangeHistoryManager();
List<ChangeItemBean> changeItems = changeHistoryManager.getChangeItemsForField(issue, "assignee") //Get assignee change history

Date assignedDate //This will contain the most recent assigned date, if one exists

if(changeItems != null && !changeItems.isEmpty()){
   changeItems.each{ci ->
      if(new Date(ci.getCreated().getTime()) > assignedDate){
         assignedDate = new Date(ci.getCreated().getTime())
      }
   }
}

if(assignedDate != null){ 
   assignedDate.format("MMM d, YYYY")
} else {
   "This issue has yet to be assigned."
}

Accepted answers

Tarun Sapra

Hello @Jake Jollimore

Please see this answer

https://community.atlassian.com/t5/Adaptavist-questions/Date-format-for-script-field/qaq-p/698130

Here you can set the custom format for displaying your date and also use the searcher "Date time range picker" so that you can query it in JQL based on your requirements.

All comments

Tarun Sapra

Hello @Jake Jollimore

Please see this answer

https://community.atlassian.com/t5/Adaptavist-questions/Date-format-for-script-field/qaq-p/698130

Here you can set the custom format for displaying your date and also use the searcher "Date time range picker" so that you can query it in JQL based on your requirements.

Tarun Sapra

So for the scripted field the template is custom but the searcher is "Date time range picker", searcher can be configured in the custom field configuration section.

Tarun Sapra

Formats available here

https://stackoverflow.com/questions/12781273/what-are-the-date-formats-available-in-simpledateformat-class

And in the dateTimeFormatter you can use the custom style (Aug 20, 2018)

https://docs.atlassian.com/software/jira/docs/api/7.6.1/com/atlassian/jira/datetime/DateTimeFormatter.html#withStyle-java.lang.String-

Jake Jollimore

This is great. Thank you! However, none of the options available in the dateTimeStyle link allow me to get the 'Aug 20, 2018' format I was hoping for. Is it possible to get a custom format?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

scriptrunner

jira

jira-server

scripted-field