date2-date1

Leo

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)"

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

Leo

hey,

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

Kind regards

Use this ninox fonction days(date1,date2)

This works as it should. Thank you very much!

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

days(start, end)

Birger