Difference Between Dates

[wort0987654321]

les ferdinand is quality

i have a date in and a dat out field. i want to be able to find the total amount of days between each of the fields. can anyone help

 

[ColinEssex]

DateDiff

 

[wort0987654321]

could you possibly give me the formula please

 

[ColinEssex]

DateDiff("d",[Date1],[Date2]) - for difference between 2 dates

or

DateDiff("d",[Date1),Now()) - for difference between date1 and today


Col