Appointment function
I wonder why this Formula shows incorrect data.
appointment('From Date' + 'From Time', 'To Date' + 'To Time')
What am I doing wrong?
-
try this
'to time' - 'from time'
-
if the duration is more than 24 hours use 'Data + Time' field
-
ekalcasino777
Thanks :-) -
ekalcasino777
But thats only the duration, right?
But why is the time showing wrong data in the other formula? -
Jan Inge Iversen
I'm new too, I can't comment )
as I understand it, "appointment" does not count just shows when the report started and when it ended, but does not count duration. It's like a board showing the value of two fields. I don't see the formula in the field DURATION, there you need to calculate the time interval. For you like this
'to time' - 'from time'
-
-
-
Jan Inge Iversen said:
But why is the time showing wrong data in the other formula?It is "not showing" the wrong data. Ninox is assuming the data in the time fields are GMT. I'm guessing you are GMT+1. I'm GMT-8 so this is what Ninox shows me:
Formula is the appointment function and Formula 2 is the datetime function.
I don't have time now to figure out how to fix Ninox's date/time issue. Maybe someone else do it before I get a chance.