Forum Discussion

DairyG1's avatar
DairyG1
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's avatar
    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's avatar
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's avatar
DairyG1
Copper Contributor
Mar 24, 2021
Matti_Paukkonen - Thank you, This looks good, much appreciated.
  • DairyG1's avatar
    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

Resources