calculating number of days

[laurat]

What expression would I use to calculate the number of days between two days.
Say one date field says 12/20/01 and the other says 1/20/02 and I want another field to display how many days are between these two date.

 

[Jon K]

Try:-

DateDiff("d", Field1, Field2)

 

[laurat]

I tried that, here is what I put:

DateDiff ("d", Date Orig, RelFloorDate)

and it told me invalid syntax, what does that mean??

 

[expublish]

DateDiff("d",[Date Orig],[RelFloorDate])

Invalid syntax means you've buggered it up in some way.

HTH

Scott.

 

[laurat]

That worked!!! Thanks for the help.

 

[expublish]

Pleasure.