Hello. I am getting the following message in SP2013. "Error calculating date. The added or subtracted value results in an un-representable DateTime. Parameter name: months". I am querying my list to pull a current date field into a variable date/time and then using the calculate date action to subtract months/years from said date to get me what the date would have been and storing this date into a date/time variable and then updating a "new date" field with this date. Not sure why I am getting this error and the question similar to this one here in the forum was never really answered. Thanks in advance.
+8
For visual clarification.
+8
The one that is failing out in the history is one that I am subtracting a year from the original due date. Could it be I am going too far back?
have you checked what's the real value of 'Due Date Old' prior it enters date calculation action?
can you write it to log and check?
+16
how are you populating variable "Due Date Old"?
+8
Ok I was able to determine that the issue was I had a field with a blank due date so and was erroring out everything because of it. I got it working. Thanks!
+8
I got it working. One field in my Due Date column was blank so then it was failing out before it could update the ones that did have a due date. Rookie error.
+16
yeah be sure to check that before you do the calculation (run if or something) to cater for that exact issue. 
Reply
View our Community Site Map
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.