Publicado Wed, 20 Mar 2019 17:18:15 GMT por Casey Miller
I have a workflow setup that when the application is approved it autofills an Approved Date field with current date. is there a way in the workflow manager that we can also fill in the Expiration Date? I can't figure out how to calculate this? It is 3 years after approval date.
Publicado Wed, 20 Mar 2019 17:23:46 GMT por Phil Robson
Casey,
2 Date variables required - GV_APPRO_DATE and GV_EXP_DATE.

GV_APPRO_DATE = CURRENTDATE
Assign this in a a data assignment step.
Create a new data assignment step (don't try to do these in one step).

GV_EXP_DATE = DATEADD("yyyy",GV_APPRO_DATE,3)

This will add 3 years to the approval date.


Phil Robson
Senior Director Support Americas
 
Publicado Wed, 20 Mar 2019 17:25:53 GMT por Casey Miller
Great information. Thanks, Phil!
Publicado Fri, 22 Mar 2019 15:16:25 GMT por Casey Miller

Phil, i have tried this but it isn't validating. This is the error it is giving me. See attached.

Publicado Fri, 22 Mar 2019 15:29:06 GMT por Phil Robson
Well that's plain unfair, because I reversed the criteria. Oops.

Try this:  DATEADD("yyyy",3,GV_APPRO_DATE)


Phil Robson
Senior Director Support Americas

 

You must be signed in to post in this forum.