I wonder why this Formula shows incorrect data.
appointment('From Date' + 'From Time', 'To Date' + 'To Time')
What am I doing wrong?
'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.
- 1 yr agoLast active