Subtract months to a date custom field and populate another date field from the result

[flan elflani]

Hi, 

the requirement is to subtract months from a date a custom field and put the result in another date custom field. 

example

Datefield2 = Datefield1 - 10 months

I could subtract days only using script runner, any ideas?

Thanks, 

Flan

[Thanos Batagiannis [Adaptavist]]

Hi Flan,

If you want the result in a scripted field then the script will br something like 

import com.atlassian.jira.component.ComponentAccessor

def customFieldManager = ComponentAccessor.getCustomFieldManager()

def months = 3
def dateACF = customFieldManager.getCustomFieldObjectByName("First DateTime")
def dateAValue = issue.getCustomFieldValue(dateACF) as Date

def dateB = Calendar.getInstance()

dateB.setTime(dateAValue)
dateB.add(Calendar.MONTH, -months)
dateB.getTime()

with

Searcher: Date Time Range picker
Template: Date Time Picker