I have a customer that wants to calculate specific dates ever year for reviewing items in a list (uses flex task too).
So an item that's been reviewed on 1/31/19 should roll to the next review on 4/30/19. The 4/30/19 should roll to 7/31/19. And 7/31/19 should roll to 10/31/19. Then, starting over, the 10/31/19 should roll to 1/31/20. You get the idea.
I calculated in Excel the datedif between these dates. See image below:
There should be 92 days between 10/31 and 1/31. This shouldn't change from year to year (unless I live on another planet).
However when I put the Calculate Date in as below (10/31/2019) is sitting in the Next Review Date field it only adds 89 to the Next Review Date and calculates 1/28/2020. That's three days less than what I put into the formula below.
I've tried all sorts of stuff to make the date come out correctly. I've put in 95 days but it still calculates wrong. I've tried 3 months. Still calculates wrong.
Does anyone have any ideas why this might be calculating wrong?
could you try following?
- write value of NextReviewDate to history log
- set up a loop from 0 too 100
- within the loop calculate date, add up value of loop index days to NextReviewDate
- write calculated date value, along with index value to history log
could you identify when the deviation starts/happens?
do you have any difference in server's, site's, your SP user profile's regional/timezone settings?
how/where exactly did you check source and calculated dates?
Thanks for responding. No change in environments on premise. Our workflows run on east coast time. But that's it. I may try this. I think Nintex should figure it out and fix it.