Please help me for date calculation
Hello
I am trying to calculate a date based on another numeric field:
Date = duedate - (number of words/ 1500} days (skipping the weekends)
How could I achieve this ?
Thank you for your help
Comments (13)
-
repo owner -
reporter Hello
- Yes number of words is a numeric field. A translator can translate 1500 words per day. Yes we have to move back 1 day per each 1500 without counting the weekends
- so 2,500 / 1,500 = 1.66. we should move back 2 days 1600/ 1500 = 1.06. we should move back 1 day
Please let me know if you need more information
-
repo owner Use "Mathematical and date-time expression calculator" post-function with the following formula:
addDaysSkippingWeekends({00012}, - round({nnnnn} / 1500), LOCAL)
replacing nnnnn with field code for "Number of words" custom field.
-
reporter - changed status to resolved
works fine thank you
-
repo owner Hi @edzeladin,
Since version 2.2.39, JIRA Workflow Toolbox supports Custom Schedules, and you can do all you are doing now using
addTimeSkippingWeekends ()
andsubtractDatesSkippingWeekends ()
functions, and much much more.I recommend you to take a look at it. You will be able to do amazing things using it.
-
reporter Hi Fidel
Thanks for the feedback. I already used subtractDatesSkippingWeekends () to calculate the time between create date and start date. I was wondering if we could add some parameters.
My company is not working between 22 of december and 2nd of january every year. How could we skip this period in the calculation.
Thanks.
Elvir
-
reporter - edited description
- changed status to open
-
repo owner Hi @edzeladin,
Can you, please, attach a screenshot of the configuration you are currently using to do the calculation?
-
reporter Yes of course
-
repo owner Use the following formula:
floor(timeDifference({11204}, {00009}, "my_schedule", LOCAL) / {DAY})
where my_schedule uses the following SDG definition:
#Mondays to Fridays we count the whole day MON - FRI { 00:00 - 00:00; # whole day interval } #Christmas holidays DEC/22 - JAN/2 {;}
Schedules are defined in JIRA at Administration > Add-ons > JIRA WORKFLOW TOOLBOX > Schedules.
-
reporter This new SDG feature works like magic.
Thank you very much
-
repo owner Hi @Elvir,
Thanks for your words. It's a very new feature, and I think it will be very valuable to most users, but it's still unknown. Please, consider sharing your experience with a little review at the marketplace listing. Thanks.
-
repo owner - changed status to resolved
- Log in to comment
I have some questions: