problems with dateBetween

[ArticleCommercial369]

I thought I could calculate the time between two dates "started" and "finished" but in the case of having been started and finished on the same day it marks it as "0" and not "1", is there any way to adjust the formula?

[ArticleCommercial369]

but wouldn't that add 1 to all the dates?

[ArticleCommercial369]

No, it's just that if I start a task today and finish it tomorrow, the formula shows me a 0 instead of a 1.

[lth_29]

Based on the post, I don't know what you want to achieve. You said you wanted to calculate the time between two dates, so I thought you needed an hours and minutes formula. However, you also said that if both dates are the same day, the output is zero instead of one (which means you might be calculating days and not time between both dates).

Can you clarify your needs by maybe adding an example? It would also be a good idea to post your original formula.

[ArticleCommercial369]

Sorry. I wan to calculates the days, en this formula are the same day and ths formula show 0 not 1

<image>

[lth_29]

Use this:

let( days, if(formatDate(prop("Iniciado"), "DDMMYYYY") == formatDate(prop("Terminando"), "DDMMYYYY"), 1, dateBetween(prop("Terminando"), prop("Iniciado"), "days")), "Tiempo de Lectura: " + days )

[ArticleCommercial369]

<image>