Date minus date to get the minutes that pass between two dates

How To
,
1

Hi

Which function do i need to use in order to calculate

the minutes that pass between the start and the current time

3

Hi,
You can use “now”

4

I use now but do I subtract ?

Now minus startAcrionDate, to know how many minutes has pass

from the start action

5

Hi @we_doc

Try formatting both datetimes as Unix Timestamp (X), subtracting, then dividing the resulting number of seconds by 60 to get the number of minutes.

{{(parseNumber(formatDate(now; X); .) - parseNumber(formatDate(parseDate(2025-10-12-10:00; YYYY-MM-DD-HH:mm); X); .)) / 60}}

You can also round the results to get an integer:

{{round((parseNumber(formatDate(now; X); .) - parseNumber(formatDate(parseDate(2025-10-12-10:00; YYYY-MM-DD-HH:mm); X); .)) / 60)}}

(fix the values when pasting, if necessary)

@damato

6

thanks, I’ve did your suggestion and it works

1 Like