Forum Discussion

Pricey79's avatar
Pricey79
Icon for Helper V rankHelper V
2 years ago
Solved

Use modified dates not originals

Hello , I was hoping someone could help me please

 

I have a few columns in sharepoint that are Date/Time columns, called Original and New. There is a third column called Duration which is a date diff of the two columns Original and New. The problem i have is that if original gets modified, the date diff takes the very first original date, not the new modified one. 

What can I do here so it uses the latest one please?

 

Any help is much appreciated

 

Thank you 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Pricey79 

     

    Based on the description of your issue, it seems that the calculation for the "Duration" column might be referencing a static value or not updating dynamically with changes to the "Original" date. 

     

    Please try the following:

     

    Ensure Dynamic Calculation for Duration：

     

    Ensure your formula is correctly set up. =DATEDIF([Original], [New], "d")

     

    Workflow or Power Automate:

     

     If the above does not resolve the issue, consider using SharePoint workflows or Power Automate to update the "Duration" column.

     

    You can create a workflow or an automation that triggers on item update, which recalculates the "Duration" based on the current values of "Original" and "New" columns.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Pricey79 

     

    Based on the description of your issue, it seems that the calculation for the "Duration" column might be referencing a static value or not updating dynamically with changes to the "Original" date. 

     

    Please try the following:

     

    Ensure Dynamic Calculation for Duration：

     

    Ensure your formula is correctly set up. =DATEDIF([Original], [New], "d")

     

    Workflow or Power Automate:

     

     If the above does not resolve the issue, consider using SharePoint workflows or Power Automate to update the "Duration" column.

     

    You can create a workflow or an automation that triggers on item update, which recalculates the "Duration" based on the current values of "Original" and "New" columns.

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.