SOLVED

Incorrect calculation using Dates

Copper Contributor

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.

3 Replies
best response confirmed by Matti_Paukkonen (MVP)
Solution

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 - Thank you, This looks good, much appreciated.
@Matti_Paukkonen,

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

Thanks
1 best response

Accepted Solutions
best response confirmed by Matti_Paukkonen (MVP)
Solution

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

 

 

 

 

View solution in original post