0

how do you calculate the days between two dates

days between two dates

8 replies

null
    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    date2-date1

    Leo

    • Christoph
    • 5 yrs ago
    • Reported - view

    if i do that, the result is sometimes 3 days 1:00. even if i use number() the result is 3,04 or something. i already checked if the date has a time but it seems not like that. it shows 23.4.2017 0:00 for "Lieferdatum" and "Datum"

    if i use this function to calculate the hours: (number(Lieferdatum) - number(Datum)) / 3600000, i get 73 (should be 72)

    i already tried "datetime(date,0)"

    • Leonid_Semik
    • 5 yrs ago
    • Reported - view

    Can it be that one of the data fields have the type datetime?

     

    Leo

    • Christoph
    • 5 yrs ago
    • Reported - view

    hey,

     

    thanks for the reply. i checked it both and it's date not datetime.

     

    Kind regards

    • deseug
    • 5 yrs ago
    • Reported - view

    Use this ninox fonction days(date1,date2)

    • Christoph
    • 5 yrs ago
    • Reported - view

    This works as it should. Thank you very much!

    • cbiswash0
    • 5 yrs ago
    • Reported - view

    how to calclute  between date (purchase date +retest priod) number

    • Birger
    • 5 yrs ago
    • Reported - view

    days(start, end)

    Birger

Content aside

  • 5 yrs agoLast active
  • 8Replies
  • 4743Views