Back to Docusign.com
I want to have on an input form a start date and a number of months field and then calculate the end date to be that number of months after the start date. The end date will also be an attribute like start date and increment number of months.
- Legacy User
Best answer by Community Expert
Hello, you can definitely achieve this by using C# expression to calculate the End Date.
Assuming you have all 3 as Var (2 date type and 1 num), in an Update Variable step the End Date var will have this value
To add any number of days to a provided date
//Get the variable containing your date/time, parse it, and add or subtract days indicated (by indicating a positive or negative number)
DateTime.Parse(GetVariableValue("StartDate")).AddDays(GetVariableValue("NoOfDays"))
Remember: the expression above does not take into account just business working days. in that case i would use this expression to calculate it:
//Create a new variable called 'current', and set it to the system dateTime for today
var current = System.DateTime.Today;
//Create a variable called 'daysToAdd' and load it with the number from your workflow variable
var daysToAdd = Int32.Parse(GetVariableValue("YOUR_VARIABLE").ToString());
//Add days until the number of indicated days is reached
for (var i = 0; i < daysToAdd; i++) {
if (current.DayOfWeek != DayOfWeek.Friday) {
current = current.AddDays(1);
}
else {
current = current.AddDays(3);
}
}
return current;
- Docusign Employee
- 1935 replies
- Answer
Hello, you can definitely achieve this by using C# expression to calculate the End Date.
Assuming you have all 3 as Var (2 date type and 1 num), in an Update Variable step the End Date var will have this value
To add any number of days to a provided date
//Get the variable containing your date/time, parse it, and add or subtract days indicated (by indicating a positive or negative number)
DateTime.Parse(GetVariableValue("StartDate")).AddDays(GetVariableValue("NoOfDays"))
Remember: the expression above does not take into account just business working days. in that case i would use this expression to calculate it:
//Create a new variable called 'current', and set it to the system dateTime for today
var current = System.DateTime.Today;
//Create a variable called 'daysToAdd' and load it with the number from your workflow variable
var daysToAdd = Int32.Parse(GetVariableValue("YOUR_VARIABLE").ToString());
//Add days until the number of indicated days is reached
for (var i = 0; i < daysToAdd; i++) {
if (current.DayOfWeek != DayOfWeek.Friday) {
current = current.AddDays(1);
}
else {
current = current.AddDays(3);
}
}
return current;
- Legacy User
- 3548 replies
Wow, Thank you so much for this answer. I will try it today and then update this post again. Your explanation is so clear and easy to follow too.
- Legacy User
- 3548 replies
I get this error. StartDate is a Date, Interval is a Num, EndDate which is this variable I am setting the expression below to is a Date. I tried with ; and without but I know that could not be it. I did set StartDate above as System.DateTime.Today;
Compilation failed: (1:71) Argument 1: cannot convert from 'string' to 'double' - Reference Id: d9a9665f-d171-427f-86d8-f4a8636aeaa5
- Legacy User
- 3548 replies
Hey I think the issue is that DateTime.Parse(GetVariableValue("StartDate")).AddDays(GetVariableValue("NoOfDays")) The part in bold wants to return a string and so I need to know how to add the part that converts NoOfDays back into a number
- Legacy User
- 3548 replies
Hello, i know there is a way to turn strings into numbers and viceversa in C# with Convert. e.g Convert.ToInt32("string")
however, I was under the impression that NoOfDays was a number Var. if not, why don't you make it consisted my converting the attribute into a NUmber Var?
- Legacy User
- 3548 replies
I still can't figure this out
Getting this error. I have StartDate as a Date Variable and NumberofDays as a number and I am trying to set a Date variable.
- Legacy User
- 3548 replies
Resolved this in another thread and confirmed it worked:
If it’s complaining that GetVariableValue("NumberOfDays") is a String rather than a Number, could you try forcing it to an Int?
DateTime.Parse(GetVariableValue("StartDate")).AddDays(Int32.Parse(GetVariableValue("NumberOfDays")))
Reply
Most helpful members this week
Sign up
Already have an account? Login
You can login or register as either a Docusign customer or developer. If you don’t already have a Docusign customer or developer account, you can create one for free when registering.
Customer Login/Registration Developer Login/RegistrationJoin the Docusign Community by logging in with your Docusign developer or customer account credentials.
Don’t have an account? You can create a free one when registering.
Note: Partner-specific logins are not available yet. Partners should log in as either a customer or developer
Docusign Community
You can login or register as either a Docusign customer or developer. If you don’t already have a Docusign customer or developer account, you can create one for free when registering.
Customer Login/Registration Developer Login/RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.