Post Function - %CURRENT_DATETIME%%

[Paolo Palermo]

Hello,

i've another problem on Jira. Follow the details

1. I have  custom Field (type date pik) called "END DATE"
2. I have a post transition on my workflow (when is the final status the custom field previously descriveb will be updated;
3. In the post function UPDATE CUSTOM FILED i've inserted %CURRENT_DATETIME%% as suggest by Jira/Add-on
4. 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.

[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%%

[Paolo Palermo]

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.