DateTools Time Difference Question

Avraham_Yerachmielbenzvi · July 5, 2021, 4:53pm

Hi All

I’m trying to…

Get the time difference between two timestamps
2 See whether the difference between two timestamps is greater than 48 hrs or 172800 sec (or should it be in milliseconds)

Any help appreciated

(I have tried reading the other comment but they doesn’t really help)

dora_paz · July 5, 2021, 5:17pm

No need for an extension. You can do it with clock component and math blocks

Avraham_Yerachmielbenzvi · July 5, 2021, 5:46pm

Hey Thanks

I see you use “Do It”.

How do I find that. What do I need to do to get it on my screen

Thanks

BTW Wher do I find that joiner you used??? (Second block form the left)

dora_paz · July 5, 2021, 5:51pm

See here

dora_paz · July 5, 2021, 6:09pm

From math blocks, it looks different cause I use External Inputs to save space.Actually the blocks are

Avraham_Yerachmielbenzvi · July 5, 2021, 6:10pm

For some reason my “Do It” is greyed out and I cannot find the connect companion anywhere

dora_paz · July 5, 2021, 6:13pm

How do you test your app’s ?

Avraham_Yerachmielbenzvi · July 5, 2021, 6:13pm

Nope, Nothing… Dont know what to do?

Avraham_Yerachmielbenzvi · July 5, 2021, 6:17pm

Testing for me takes ages. I compile, download, install; on phone, look, uninstall, clear phone and do it all over again…**.EVERY TIME!

I think we are go crossed wires.

Connect companion, I have. I assume Do it will activate then - Gotcha

As for tge two blocks under / next to each other, Im still stuck

dora_paz · July 5, 2021, 6:24pm

Avraham_Yerachmielbenzvi · July 5, 2021, 6:25pm

dora

Avraham_Yerachmielbenzvi · July 5, 2021, 6:27pm

sorted Thanks

dora_paz · July 5, 2021, 6:28pm

Avraham_Yerachmielbenzvi · July 5, 2021, 6:33pm

Thanks Dora (again)!

Taifun · July 7, 2021, 9:12pm

8 posts were split to a new topic: How to convert date formats?

Avraham_Yerachmielbenzvi · July 7, 2021, 12:16pm

my post just shows the solution

Rogerio_Rios · July 7, 2021, 1:00pm

No .
This topic is about difference between dates time and not setting dd/mm/yyyy to write to the database.

Avraham_Yerachmielbenzvi · July 7, 2021, 3:25pm

Actually, this post evolved into two issues. Only discovered once it was ascertained that there were inherent problems with MySQL and the date-time format as well.

So "In effect, we killed two birds with one stone. (no offence to any birds out there)
You have to be so careful these days

Rogerio_Rios · July 7, 2021, 4:49pm

I don’t agree, but I’m not a moderator.
Each topic should be about a subject and have its unique solution to help other users (it’s not always like that, but it should be like that, I think)
There were no problems with Mysql.
And if there were problems about Mysql on Google we have thousands of solutions.
The user above solved the problem of the difference of date and time…
But …

Taifun · July 7, 2021, 9:13pm

I now split the 2 subjects into 2 threads
Taifun