0

Appointment function

I wonder why this Formula shows incorrect data.
appointment('From Date' + 'From Time', 'To Date' + 'To Time')

 

 

 

What am I doing wrong?

7replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • try this

     'to time' - 'from time'

    Like 1
    • if the duration is more than 24 hours use 'Data + Time' field

      Like 1
    • ekalcasino777 
      Thanks :-)

      Like
    • ekalcasino777 
      But thats only the duration, right?
      But why is the time showing wrong data in the other formula?

      Like
    • 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'

      Like
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view
    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.

    Like
Like Follow
  • 2 mths agoLast active
  • 7Replies
  • 55Views
  • 3 Following