Compare two Date Picker fields - JMWE - Validator

Question

I have two field, both of them are Date Picker type fields.

example:

1. Date X

2. Date Y

If you select June 15th for the Date X field, and you select June 12th for the Date Y field, an error will occur. (cannot do the backdated process).

How to achieve that?

Tansu Akdeniz · Accepted Answer

Hi @RIZKY JTUASIKAL

Go to

* Project settings -> workflows and edit the workflow.
* Find Create transition and click validators.
* Add Validator -> Date Compare Validator and compare date fields.

Avinash Bhagawati _Appfire_ · Accepted Answer

Hi @RIZKY JTUASIKAL ,

As per the the attached tags to the post, you would to achieve your requirement using JMWE then you can use "Scripted validator"  with below sample code.

https://appfire.atlassian.net/wiki/spaces/_/pages/78480377?atlOrigin=eyJpIjoiMzkzYmYyZjBjZGY3NDc5NWIyOTNlYzRkZWFhMjEyNDQiLCJwIjoiYyJ9

!! issue.customfield_10183 && !! issue.customfield_10184 && ( new CalendarDate(issue.customfield_10184) > new CalendarDate(issue.customfield_10183))

In above customfield_10183 and customfield_10184 refers to Date X and Date Y respectively.

Please note that above code fulfils with two validations, i.e both Date X and Date Y are required fields and Date Y > Date X.

Additionally, you can use built in/native  "Date Compare validator" compare Date X and Date Y.

Thanks,
Avinash