Subtraction of time

some example to subtract hours

greetings

Hi Fransisco @freeser1,

Welcome to the forum!

Internally Adalo stores Date&Time in a specific format - as a number of days since 01/01/1970.
So if you would like to subtract a specific number of hours, you need to subtract 1/nb_of_hours. E.g. on this screenshot I’m subtracting 2 hours from “Logged-in User → Some Time” database property and storing the result in the same property:

Screenshot 2024-06-17 at 13.38.33

Best regards, Victor.

1 Like

Thank you Victor

I really appreciate your contribution, you helped me.

Do you have a tip on how to make the entry of the fields uppercase?

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.