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"))

Matti_Paukkonen

MVP

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