date comparison in workflow

[NM]

Hi,

We have a use case where we have to send entitlement for approval based on difference between the end and start date.

if enddate-startdate is greater then 2 months send to user group for approval otherwise to manager for approval.

I tried with request_access.startdate - request_access.enddate but that doesn't seem to work (No request is getting submitted)

Can someone please provide a sample to use enddate and startdate in workflow?

Thanks

[rushikeshvartak]

com.saviynt.ecm.workflow.Request_Access.get(new Long(requestaccesskey)).startdate.format("HH").toInteger()>17

[NM]

Hi Rushikesh,

Tried with the one provided by you in if else block it doesn't seem to work, Received below error message.

"Script evaluation error"

Expression language selected is "Groovy"

Condition

[rushikeshvartak]

Above one was sample please change as per your requirements 

[NM]

I will make the changed as per the requirement but the above provided one also doesn't work. Do I need to add something else to make it work?

Thanks

[rushikeshvartak]

com.saviynt.ecm.workflow.Request_Access.get(new Long(requestaccesskey)).startdate.format('HH').toInteger()>17

[NM]

I have tried this but gives an error and mentioned the same in my previous comment..

[rushikeshvartak]

com.saviynt.ecm.workflow.Request_Access.get(new Long(requestaccesskey)).startdate.format('HH').toInteger().equals('17')