Hello, i've another problem on Jira. Follow the details * I have custom Field (type date pik) called "END DATE" * I have a post transition on my workflow (when is the final status the custom field previously descriveb will be updated; * In the post function UPDATE CUSTOM FILED i've inserted %CURRENT_DATETIME%% as suggest by Jira/Add-on * The field is correctly updated with the date of transition Problem When i try to a query on this field, the query response me always with Zero Element. The problem is that the date is not saved correctly. Could you help me? I insert e picture for help me in the analisys.

Ciao Mizan, i didn't found another solution. If i update manually the custom-field i don't have any problem. My target is to have query in orther to get Defect closed day by day. Thanks in advance.

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

Post Function - %CURRENT_DATETIME%%

Paolo Palermo

Hello,

i've another problem on Jira. Follow the details

I have custom Field (type date pik) called "END DATE"
I have a post transition on my workflow (when is the final status the custom field previously descriveb will be updated;
In the post function UPDATE CUSTOM FILED i've inserted %CURRENT_DATETIME%% as suggest by Jira/Add-on
The field is correctly updated with the date of transition

Problem

When i try to a query on this field, the query response me always with Zero Element. The problem is that the date is not saved correctly.

Could you help me? I insert e picture for help me in the analisys.

Query Based.JPG

Accepted answers

All comments

Mizan

What result you get when you use

"End Date" > "2017/10/09" and "End Date" < "2017/10/10"

it seems like an issue with "=" operator.

Try to export the result and verify what value is saved in the End Date field . Does it store the date and time value. If yes , this is the issue

Paolo Palermo

Ciao Mizan,
you are right, i've the result. The reason is in the date is present not only date but hh mm : ss
Ex 09/10/2017 12:39:00

Could you suggest me a function in order to have only the date YYYY /MM /DD ? For me is important.

Now i'm using %%CURRENT_DATE TIME%% function, Exist Current_Date for istance?
Please help me as soon as possible.

Paolo Palermo

Any News?

Mizan

Sorry Sir .. this is the soonest I could reply you.

Sad news is that I dont know the answer for this.

What you want to achieve ?

Is the workaround insufficient .. did you try anything in the meantime ? Made mistakes ?

Did you try to search any other date field or update this date field manually and checked if it works as expected ?

Or have you tried %%CURRENT_DATE%%

Welcome!

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

Quick Links

Find more posts tagged with

jira