[JMWE] Compare the current date (system date) with a date field

RIZKY JTUASIKAL

When we want to submit a status, from status A to status B, there is a validation to compare the current date (the day the status was submitted) and the value of the MoA Signed Date field.

- If the current date is less than 3 months from the MoA Signed Date, then JIRA can be submitted.

- If the Current Date is more than 3 months from the MoA Signed Date, then JIRA fails to submit and an error message appears.

 

is there a simple way to get this validation? (maybe using the Date Compare Validator feature?) or do you have to use the following features: Build-your-own (scripted) Validator (JMWE app)?

please help, and thanks in advance

David Fischer

Hi @RIZKY JTUASIKAL 

you can easily implement this using JMWE's Build-your-own (scripted) Validator, using a script like this:

new Date().toCalendarDate() <= issue.customfield_12345.plusMonths(3)

where  customfield_12345 is the custom field ID of field MoA Signed Date. This assumes that MoA Signed Date is a Date Only custom field. If it's a Date/Time field, the script would be:

new Date() <= issue.customfield_12345.plusMonths(3)