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; } } }

How Can I Compare a Custom Field like "User 1" ( mapped a Date field) to Due Date field?

Raghavendra kaushik

Hello,

We have mapped a Custom Field : "User 1" as "Planned Start date". In my Dashboard JQL query, I would like to filter all my stories where "User 1" ( Planned Start Date) value is greater than my current date.

1. Is there a way I can convert my custom field - ( User 1) to a Date field?

2. secondly, for comparing against current date, is 'startOfDay()' the right function to be used in JQL?

Thanks

Accepted answers

All comments

Jack Brickey

Hi @Raghavendra kaushik , you cannot use JQL to compare two date fields. You could create an Automation rule to compare the dates and add a label or comment. You cannot change a custom field to a different type. You could create a new field of type date and copy the data over thru various means, e.g. export/import, automation rule.

Raghavendra kaushik

Thanks Jack.

Since I am new here. Can you please elaborate step wise?

Regards,

Raghavendra Kaushik

Jack Brickey

Hi @Raghavendra kaushik

if you are looking for step-by-step example of an automation rule to compare to dates, there are quite a number of posts in the community that discussed this. Here is The result from a quick search I did. This documentation reference is also extremely valuable understanding how date fields work - jira-smart-values-date-and-time . Understanding more about your specific use case would allow me to provide a more detailed response.

Raghavendra kaushik

Hi Jack,

Here is my use case:

1. I have custom field named as "User 2" in which I am storing a date value . example: 2023/03/10.

2. I need to compare the above stored date value with a JIRA date field , say "Due Date". Also, How can I compare the above stored date value ( in User 2 field) with functions like 'now() or 'startOfDay()'.

Please help with the above requirements.

Also, I did look at the various links provided by you. It seems "Creating a Variable via automation" is possible on Cloud version only and not on premise version.

I just realized, in our Org we might using On premise and Not Cloud ( I am not sure). Below the dashboard page, I saw the version number mentioned (attached screenshot). Please do throw some light on this as well- if such automation is even possible on premise version or not.

Thanks

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud