Publicado Wed, 20 Mar 2019 17:18:15 GMT por Casey Miller Solutions Manager
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 DocuWare Corporation Senior Director Professional Services, Americas
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 Solutions Manager
Great information. Thanks, Phil!
Publicado Fri, 22 Mar 2019 15:16:25 GMT por Casey Miller Solutions Manager

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 DocuWare Corporation Senior Director Professional Services, Americas
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

 
Publicado Mon, 30 Mar 2020 12:44:57 GMT por Koen Logghe Technical Training & Support Specialist
Dear Phil, 
Thanks for this explaination, I would like to add some days, e.g. 5 to my date.
I should expect below command is for that:
DATEADD("dd",5,GV_ApproveDate) 

But I receive below error:
 [2: ExpiredDate] Invalid Argument Value for argument Interval: [DD]

Can you please tell me where is the wrong ?
Best regards,
Koen Logghe

 
Publicado Mon, 30 Mar 2020 13:34:11 GMT por Simon H. Hellmann Toshiba TGIS GmbH | IT-Consultant - Document Management Solutions
Hi Koen,

you are using the wrong syntax. Please refer to this page: DateAdd in VBA
Your command should be:
DateAdd("d",5,GV_ApproveDate)

Hope this helps.

Greetings from Germany,
Simon H. Hellmann
DocuWare System Consultant
Publicado Mon, 30 Mar 2020 14:35:42 GMT por Koen Logghe Technical Training & Support Specialist
Hi Simon,
Thanks a lot, this helped me out !

Best regards,

Koen Logghe
 

You must be signed in to post in this forum.