Mar 22 2021 01:16 PM - edited Mar 22 2021 02:15 PM
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 have added the calculated column and the output on sharepoint list
Please see attached..Thank you for your time.
Mar 22 2021 10:14 PM
SolutionHi @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"))
Mar 24 2021 08:38 AM
Mar 25 2021 10:09 AM
Mar 22 2021 10:14 PM
SolutionHi @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"))