Date fields format

[Paolo Pastorino]

Good afternoon,

in JPD we use date fields for tracking Dev start/end dates.

When we pull them in a filter and then a dashboard this is what I get (I knew it was a problem in the past but I thought it was fixed). Any advice?

Thanks

[Bill Sheboy · Accepted solution]

Hi @Paolo Pastorino 

That is the date format which JPD uses, helping to handle a range of values.

For other things like filters and dashboards, we are "stuck" with those text values of the dates.  Some possible workarounds are:

• if exporting the data, parse the field to convert to a date type
• if displaying the data in a Jira filter or dashboard...
  • add another custom field in global settings for a date picker
  • add that global field to your JPD project's fields
  • use automation rules to set the new custom field when the JPD one changes
  • use the new custom field in your filter results or dashboard

Kind regards,
Bill

[Paolo Pastorino]

Thanks Bill.

This was raised long ago with the JPD product team as, while it is presented as a date range, when I create it I can just enter one date, not a range.

I will give a try to the other options

Thanks

[Matt Shaffer]

Unless I have missed something there is no way to create a "Global Field" or "Custom Field" that has the type of "Date Picker".

If you select the type of "Date", it is the JPD version of a "Date Picker", which lets you choose quarter, month, day etc. which it then stores as the string version of the "Date" object.

I was trying to copy the "due date" field from the delivery ticket that the idea was linked to, to a custom field in the idea.

The goal was to have a Dashboard that showed which ideas were overdue on a quarterly basis.

The only way I could get the "due date" to propagate was by creating a custom field of type "short_text_box" and copying it from the triggering issue.

This does not help when you are trying to use the data in any way as a "date" in jira. (what things were due last quarter)

If anyone knows different, please let me know. 

PS. No, I do not have script runner.