Count difference between two dates

[Costa]

Hello all ..

I want to add formula in a field to count the difference between two dates that are stored in another fields.

Example:

Field 1 : Start Date : 1 march 2010
Field 2 : End Date : 15 march 2010
Field 3 : Number of days between field 1 and field 2

What is the formula to count the number of days between field 1 and field 2 ?

OR just count it without adding it to a field

Waiting for your help .. Thanks

[pbaldy]

Check out the DateDiff() function.

[Costa]

Can you please give me the code ?

my fields name are :

Startdate
End-date
Diffdate

I think DateDiff() is to add the dates manually not to take them from records in fields.

Thanks for your help mate

[pbaldy]

There should be a pretty good description of the function and its arguments in Help. It can certainly get its values from fields.