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
    • 2 yrs ago
    • Reported - view

    try this

     'to time' - 'from time'

      • ekalcasino777
      • 2 yrs ago
      • Reported - view

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

      • Producer, Manager
      • Jan_Inge_Iversen
      • 2 yrs ago
      • Reported - view

      ekalcasino777 
      Thanks :-)

      • Producer, Manager
      • Jan_Inge_Iversen
      • 2 yrs ago
      • Reported - view

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

      • ekalcasino777
      • 2 yrs 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
    • 2 yrs ago
    • Reported - view
    Timer.ninox
    • Fred
    • 2 yrs 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.

Login to reply

Content aside

  • 2 yrs agoLast active
  • 7Replies
  • 92Views
  • 3 Following