Get the close date to Custom field

[Lokesh Gowda]

Hello,

I would like to capture the issue closed date and time to a custom field, I have created the custom field as Date and time picker and added the post function to write the date to the custom field.

I have added the groovy and getting the Close date but its showing as "2 days ago", "1 day ago" and 1 minute ago its not give the data. When i pull the report we are not getting any output in the CSV.

Please find the Groovy script and the custom field value.

import com.atlassian.jira.component.ComponentAccessor
import java.sql.Timestamp
def customFieldManager = ComponentAccessor.getCustomFieldManager()
def dateCf = customFieldManager.getCustomFieldObject("customfield_10104") // Date time fields require a Timestamp
issue.setCustomFieldValue(dateCf, new Timestamp((new Date()).time))

CloseDate

Date Time Picker

Please find the Screenshot for the same

Can you please help me to solve this issue.

[John Funk]

Hi Lokesh,

You can turn off relative dates by following this article:

https://confluence.atlassian.com/jirakb/display-standard-dates-in-jira-server-414187622.html?_ga=2.24967162.1132808388.1589116439-1313086432.1576012938

What does the value look like in the actual CSV?

[Lokesh Gowda]

Hi John,

In the CSV we are able to see the date and time, but in the JQL we are seeing only the # of days or mins

[John Funk]

So the CSV is good. Did you turn off the Relative dates based on the article above?

[Lokesh Gowda]

After doing these changes should I need to restart the JIRA servers? 

[John Funk]

Not sure - maybe just do a re-index?

[Lokesh Gowda]

Thank you very much, after setting jira.lf.date.relativize = false its showing the Date and time. 

[John Funk]

Great! Glad I could help a little.