Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How to filter "createdData" field from specific time?

clarabez
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 23, 2018

I need to filter every request that has been created from 3pm for every day/period, where "DueData" is for the same day. So, I need a static value (so "YYYY/MM/DD" will not work for me).

 

The reason for that:

I need to calculate the impact for every late request created from 3pm, for every day, for my team.

 

I know I may use:

created >"YYYY/MM/DD HH:mm" [...]

for specific days, but not for "StartOfYear" or any other function.

1 answer

1 accepted

1 vote
Answer accepted
Randy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
March 23, 2018

for something like this, i would just export and run the report in an external tool like excel.

 

If you want to keep it in jira you can add a scripted checkbox field that is checked if it was created after 3pm for the day.  Requires ScriptRunner and some scripting though.

clarabez
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 18, 2018

Thanks for you response, Randy!

I will try it out =) 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events