Tested value is different than the one displayed in the Form

Alexis
New Member

Hi,

I’m using a time type in my app (it’s a starting time).

I have a form to create an appointment, and the initial value is calculated from the current time and rounded to the next quarter.

When I test it, it works fine (I’m testing it at 3:50 PM shows me 4:00 PM), but it doesn’t work in the form (Shows me 4:05 PM).

It doesn’t make sense to me. Any idea ?

Solved Solved
0 3 167
1 ACCEPTED SOLUTION

Alexis
New Member

I separated the hour and minute values to find which one was buggy, they both were.
After some unsuccessful changes, I’ve remplaced every NOW()-"0:00" by TIMENOW() - "00:00:00"

It works perfectly now.

Thank you for your help

View solution in original post

3 REPLIES 3
Top Labels in this Space