Use modified dates not originals

[Pricey79]

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 

[Anonymous · Accepted solution]

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.

[Pricey79]

@Anonymous Thank you 🙂