How to display a date range column as a simple date in product discovery ?

[Jennifer Chang]

I'd like to receive certain tickets from product discovery from slack on daily basis, so I created a jira automation within product discovery and slack. With this slack message, I received the ticket list with date column, the date column it's format is date range not a specific date, so it's hard to read (please refer my screenshot).

Is there any way we can display the date range as a simple date and easy to read ?\

[Bill Sheboy · Accepted solution]

Hi @Jennifer Chang -- Welcome to the Atlassian Community!

You appear to be sending the Slack message with an automation rule.  Is that correct?

As you have observed, JPD is using its own type of date field, which is actually text to represent a range of date values.  For example:

{"start":"2023-10-31","end":"2023-10-31"}

And so to get just one date value, that needs to be extracted, and possibly converted to a format which can be used.

Here are some examples to extract the dates for a custom field:

My start date: {{issue.customfield_10102.match(".*start\":\"(.*)\",.*").toDate.jiraDate}}

My end date  : {{issue.customfield_10102.match(".*end\":\"(.*)\".*").toDate.jiraDate}}

These use the text function match() to extract the values, and the date function toDate to convert it, and finally jiraDate for the formatting.  Please use another format, as needed.

To learn more about these functions, please look here:

• https://support.atlassian.com/cloud-automation/docs/jira-smart-values-text-fields/#match--
• https://support.atlassian.com/cloud-automation/docs/examples-of-using-smart-values-with-dates/#Converting-text-to-dates
• https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-format---

Kind regards,
Bill

[Jennifer Chang]

Hi @Bill Sheboy , thank you so much for your reply! yes I was trying to send the Slack message with an automation rule. I use the example you provided, it is very useful, it works!! thanks a lot!

[Hermance NDounga]

Bill, you're the automation hero of this community 🚀 Thanks a lot ! 

[Bill Sheboy]

Awesome; I am glad to learn that helped, Jennifer.

And thank you, Hermance. Glad to try to help  :^)

[Rabeeh Adwan]

Hello @Bill Sheboy , is there a way to add a field with the same type used for "Start date" in Jira?

[Bill Sheboy]

Hi @Rabeeh Adwan -- Welcome to the Atlassian Community!

Do you mean in a Jira Product Discovery (JPD) project? 

If so, I believe all date, custom fields added to a JPD project are that type.  Outside of JPD, I do not believe that field type exists: they are Date Picker or Date / Time Picker fields.

Perhaps someone from the Atlassian team will comment to confirm this.

Kind regards,
Bill