Skip to main content
Nintex Community Menu Bar

Calculate time duration between today and the date a specific field was changed

  • December 9, 2019
  • 2 replies
  • 10 views
Forum|alt.badge.img+2

I have a list/form that is amended by several teams and therefore the list items have a modified date of whichever team amends it last.

For KPIs I am trying to calculate where bottle necks are and which teams are potentially delaying a process. I was hoping to be able to take the date that the Status choice control was changed and compare the difference in time to that of [Today] to see how long it is between status changes. Basically the status gets changed as the process progresses. 

 

I am assuming it is a calculated value that I would need to use but have no idea how to get the last modified date from the Status choice control. 

    2 replies

    Simon Muntz
    Nintex Partner
    Forum|alt.badge.img+23
    • Simon MuntzNintex Partner
    • Nintex Partner
    • December 9, 2019
    HI,

    SharePoint does not keep track of individual column modifications only the whole list item itself so I do not think what you are trying to do will be possible.
    We provide Nintex Training & Consulting - https://www.definiti.com.au/
    Forum|alt.badge.img+12
    • kunalpatel
    • Scholar
    • December 9, 2019

    @Kaz_W , @SimonMuntz .....What about enabling versioning? In version history it will show only those columns where values are change.

     

    Also, if it's the name and date you want to grab then maybe you everytime the item is modified you can grab the modified by and modified date. Also if you want Dept. Manager's info....then using Query User Profile of Modified By you can get those information and save it in a different list.

    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsAccessibility statement