Adding 3 years to current year

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.

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
 

Great information. Thanks, Phil!

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

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

 

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

 

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

Hi Simon,
Thanks a lot, this helped me out !

Best regards,

Koen Logghe