nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help comparing 2 date fields in a workflow?

Warren McInnes

Hi,

I have a workflow where on one of the transitions we need to check two date fields and either allow the transition or deny it.

we need this type of comparision:

"My custom field/future date" > CurrentDate()/today's date

So therefore, If the future date is larger than today's then allow transition, if it is not then give an error?

Is there anyway to achieve this? Script runner perhaps?

Thanks,

Warren

Accepted answers

Justin Alex Paramanandan

You can install the Script Runner plugin and add a validator to the transition you've mentioned with the following settings:

Validator type: Script validator

Script:

Date now = new Date()
Date cfDate = new Date(cfValues['DateFieldA'].getTime())
new Date(now.getYear(), now.getMonth(), now.getDate()).compareTo(cfDate) &lt;= 0

Replace DateFieldA with your Date Picker custom field's name.

*updated to reflect the comments of this answer.

All comments

Nitram

Hi,

This can be done, Write a workflow condition plugin which will help you to do this, look into this link, which may help you,

http://www.j-tricks.com/1/post/2010/08/workflow-condition.html

Hope this helps!

Justin Alex Paramanandan

You can install the Script Runner plugin and add a validator to the transition you've mentioned with the following settings:

Validator type: Script validator

Script:

Date now = new Date()
Date cfDate = new Date(cfValues['DateFieldA'].getTime())
new Date(now.getYear(), now.getMonth(), now.getDate()).compareTo(cfDate) &lt;= 0