HELP: How to calculate period of time?? (1 Viewer)

[AnnaZ]

Hello,

I have two fields, one contains start date, the other contains end date. Is there a way to construct a third field that would display the number of days between those two fields? For example, start date is 01/04/2004, end date is 01/14/2004, I would need the third field to count and display 10 (10 days).

Thanks in advance for any help.

Anna

 

[The_Doc_Man]

In the Help Files look up DateDiff function and note that you would use "d" for the units specification.

 

[AnnaZ]

Thanks for your help. I did not find DateDiff in the help files, although I did see it as one of the functions available. I'm not familiar with this function, but I tried to build this expression for my field:
Expr1: DateDiff ([Date Entered], [Date Left]) , but of course this syntax didn't work. Any suggestions??

Thanks.

 

[AnnaZ]

Or can't I just do this:
Date Left - Date Entered

Wouldn't this give me the number of days in between?

 

[joseph.shepherd]

Try this:
var = DateDiff("d", StartDate, EndDate)