Calculate number of days between two dates

[#1]

Hi all, I`m trying to calculate the number of days between to dates and it doesn`t work. The first date is the beginning date and the other date the date of construction. The format of the dates are "27.01.2012". I hope you can help me!

[#2]

Hi there,

take a look at the example-textboxes in the attached app. Using expressions like these depend on the enviroment but they should point into the right direction.

HtH

Roland

[rohit214]

Hi

try this

Num(Date( beginning date ,'DD-MM-YYYY'))-Num(Date(date of construction.,'DD-MM-YYYY))

as Diffrence

may it helps

you

thans

rohit

[#4]

Many thanks, I will try it!