Skip to main content
Nintex Community Menu Bar

Error calculating date

  • Sep 12, 2017 12:33 PM UTC
  • 7 replies
  • 48 views
  • Translate All

Forum|alt.badge.img+8

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.

‌

7 replies

Forum|alt.badge.img+8
  • Author
  • Sep 12, 2017 12:47 PM UTC

For visual clarification.

Translate

Forum|alt.badge.img+8
  • Author
  • Sep 12, 2017 12:59 PM UTC

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?

Translate

Forum|alt.badge.img+14
  • Scholar
  • Sep 12, 2017 1:13 PM UTC

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?

Translate

Forum|alt.badge.img+16

how are you populating variable "Due Date Old"?

Translate

Forum|alt.badge.img+8
  • Author
  • Sep 12, 2017 2:31 PM UTC

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!

Translate

Forum|alt.badge.img+8
  • Author
  • Sep 12, 2017 2:33 PM UTC

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.

Translate

Forum|alt.badge.img+16

yeah be sure to check that before you do the calculation (run if or something) to cater for that exact issue.  happy.png

Translate