Flow not calculating the correct days or hours

(0) Share

Report

Posted on by jbrines

1,121

Hi Guys,

Thanks to the help of another member @fchopo I have got my flow that works out the days or hours since a column Date Reported was added. The issue is that it isn't bringing back the correct days or hours. I was hoping one of you kind members can help. The Date reported Date is 22/12/20 10:30

Flow

Flow Results

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

v-litu-msft on at

Like (1)

Report

Re: Flow not calculating the correct days or hours

Hi @jbrines,

I think it is caused by the time zone.

The utcNow() function returns Coordinated Universal Time, so you should convert it to the time in your time zone:

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
jbrines 1,121 on at

Like (0)

Report

Re: Flow not calculating the correct days or hours

@v-litu-msft Still doing the same. I am in the UK so was much to convert.

Days show 0 and hours show 13. Not all the list items show dates as they have still to be added.

Was this reply helpful? Yes No
v-litu-msft on at

Like (0)

Report

Re: Flow not calculating the correct days or hours

Hi @jbrines,

Are these dates always has the same time gap?

If they are, you could consider using addHours() function to adjust them.

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No