How to validate Due date with system date or today's date ??

[Arpit Doshi]

Hi,

I am using a Due Date field in my create screen but I am not able to validate it against system date or today's date.
When I use date compare validator and compare Due date with created date it didn't work because while creating a ticket created date is null !!

Thanks !!

[Dieter · Accepted solution]

In case where all the other weapons fail, i always consider implementing something like that using a groovy workflow validator script. just install the Groovy Script Runner plugin which should also be available for your version. Something like the following in the validator of the create transition should do the job: invalidInputException = issue.getDueDate().after(new Timestamp(System.currentTimeMillis())) ? null: new InvalidInputException("due date must be in future!") I assume you made due date a required field else you would also have to handle the case issue.getDueDate() == null

[Dieter]

Sorry for the bad formatting, aac still doesn't work well with iPad

[JamieA]

Just tested Dieter's solution and it worked fine. I made a couple of minor tweaks:

import com.opensymphony.workflow.InvalidInputException

if (issue.dueDate) {
    if (issue.dueDate.before(Calendar.getInstance().getTime())) {
        invalidInputException = new InvalidInputException("Due date must be in the future.")
    }
}

[Mageswari]

I'm not a technical person; Could you pls. guide me on where to add the mentioned script.

Thanks.

[JamieA]

Not beyond saying read the documentation. If you're not a technical person and don't want to read up on it you probably need another plugin to be honest.

[Neeta Dubey]

I've have a custom date field "first date". I've modified the script accordingly and placed it at create event however its not validating my first darft date field. It's still accepting past date values. Could you please advice? import com.opensymphony.workflow.InvalidInputException if (issue.First Draft) { if (issue.First Draft.before(Calendar.getInstance().getTime())) { invalidInputException = new InvalidInputException("First date date must be in the future.") } }

[Dieter]

Please replace all occurences of issue.First Draft by cfValues ["First Draft"] Only system fields have getters lije dueDate

[Neeta Dubey]

i edited my code however it's still the same. import com.opensymphony.workflow.InvalidInputException if (issue.cf[13919]) { if (issue.cf[13919].before(Calendar.getInstance().getTime())) { invalidInputException = new InvalidInputException("date must be in the future.") } }

[Neeta Dubey]

workflow.JPG

[Dieter]

Please look at https://jamieechlin.atlassian.net/wiki/plugins/servlet/mobile#content/view/1212434 howvto correctly use the map cfValues. issue.cf[fieldid] doesn't work cfValues['name of field'] instead shoukd work

[JamieA]

As Dieter said.

[Ronald Horner]

I would do it in your validator for the Start Progress transition so that your Created date is set. Additionally you won't be able to start progress on a task that has a due date before the created date. This won't require you to use a plugin to get the functionality you are looking for.

However if you want to do it on the Create Issue transition then I would use the JIRA Workflow Enhancer Plugin. Use the Universal Validator on the Create Issue Transition with the following settings:

Expression:

{Due Date} > [now]

Evaluate To:

true

[Mageswari]

Thanks, Ronald. Validating an issue in start progress will nor work for me, since we do not want an issue created with a faulty due date. That option gets ruled out;

Workflow enhancer not available for JIRA 4.0.1 used by us.

Also tried the Date compare with Due date and a custom field that populates current system time for comparision - No Use.

[Mageswari]

Hi,

Have the same problem; Since JIRA accepts past dates in Due date field - would like to validate my due date to be equal to or greater than current date. With Date Compare validator - Says, 'Error creating issue: Could not load validator class'.

Any answers on this would be helpful.

Thanks.