0

Number of days between 2 days of appointment

Hi

I have the function date(start(appointment)) but I don’t have the function date(end(appointment))! How can I calculate number of days between 2 appointments date? I don’t want to use the function day(date1,date2).

thank you

8 replies

null
    • gold_cat
    • 5 mths ago
    • Reported - view

    I'm not sure I understand it correctly and you can try it

    • pabodart
    • 5 mths ago
    • Reported - view

    Thank you  but it concerns directly the field "Appointment " !

    • szormpas
    • 5 mths ago
    • Reported - view

    Hi, For the second day, you will need:

    date(endof('Appointment') )

      • pabodart
      • 5 mths ago
      • Reported - view

       

      thank you very much it’s working perfectly but I need just a number, the answer of my function send me back "x days"…

      • szormpas
      • 5 mths ago
      • Reported - view

       can you share with us your whole function or can you be a little more specific about what you are trying to achieve? 

      • pabodart
      • 5 mths ago
      • Reported - view

       it’s for quantity a number of nights for a rental time

      • szormpas
      • 5 mths ago
      • Reported - view

      , I'm glad you found the solution!

    • pabodart
    • 5 mths ago
    • Reported - view

    I find it:

    days(date(start(Date)), date(endof(Date)))
    Thank you

Content aside

  • Status Answered
  • 5 mths agoLast active
  • 8Replies
  • 39Views
  • 3 Following