How to display time difference (date - date) as HH:MM?

[davi.simao]

Description:

Hi everyone,

I’m having trouble working with a variable of type “evaluates to a date”.

What I’m trying to do:

• Take the current date/time and subtract another date.

• I want to display the result on the front end as HH:MM.

The issue:

• Bubble only lets me format the result as days, hours, minutes, or seconds, but not directly in the HH:MM format.

• I’m currently using a text element to display the value.

Question:
What’s the correct way to format a date difference and display it as HH:MM in Bubble?

[mario11]

Here’s how you can achieve this in Bubble:

The Challenge:

When you subtract dates in Bubble, you get a date interval (measured in milliseconds), but the built-in formatting options don’t directly give you HH:MM format.

The Solution:

You’ll need to use mathematical operators to convert the date interval into hours and minutes:

1. Calculate Hours: Use Date difference :formatted as hours to get the total hours
2. Calculate Minutes: Use Date difference :formatted as minutes and then use the modulo operator (%) with 60 to get remaining minutes
3. Format as Text: Combine these in a text element like: Hours & ":" & Minutes

Example Expression:

In your text element, you could use something like:

Current date/time - Other date :formatted as hours & ":" & (Current date/time - Other date :formatted as minutes % 60)

Important Note:

Once you format a date using :formatted as, it becomes text and can no longer be manipulated as a date. That’s why we use the mathematical approach instead.

This approach gives you the precise HH:MM format you’re looking for while working within Bubble’s date handling system!

[davi.simao]

tku men!

I have used this logic:

((Data A - Data B):formatted as minutes) ÷ 60 :floor & “:” & ((Data A - Data B):formatted as minutes mod 60):formatted as 00

[mario11]

Sounds good