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?

7 replies

null
    • ekalcasino777
    • 1 yr ago
    • Reported - view

    try this

     'to time' - 'from time'

      • ekalcasino777
      • 1 yr ago
      • Reported - view

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

      • Producer, Manager
      • Jan_Inge_Iversen
      • 1 yr ago
      • Reported - view

      ekalcasino777 
      Thanks :-)

      • Producer, Manager
      • Jan_Inge_Iversen
      • 1 yr ago
      • Reported - view

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

      • ekalcasino777
      • 1 yr ago
      • Reported - view

      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'

    • ekalcasino777
    • 1 yr ago
    • Reported - view
    • Fred
    • 1 yr 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.

Content aside

  • 1 yr agoLast active
  • 7Replies
  • 83Views
  • 3 Following