Forum Discussion

Copper Contributor

Mar 22, 2021

Solved

Incorrect calculation using Dates

Hello All, I have a simple date calculation that is showing incorrect. I need the time in days/hours/mins between two date/time fields Both dates are calculated using utcNow() in flow. I've ha...

SharePoint Online

Matti_Paukkonen
Mar 23, 2021
Hi DairyG1,

You need to calculate days between two dates with DATEDIF function.

Here is my example, check that column names are correct.

=CONCATENATE(DATEDIF([EDT Assigned Date],[SC Submitted Date],"d"),":",TEXT([EDT Assigned Date]-[SC Submitted Date],"hh:mm"))

DairyG1

Copper Contributor

Mar 24, 2021

Matti_Paukkonen - Thank you, This looks good, much appreciated.

DairyG1

Copper Contributor

Mar 25, 2021

Matti_Paukkonen,

some entries in the list are coming out with Name? and some entries are working fine..Any ideas?

Thanks