Number of days/months between 2 dates

[YNWA]

I have a table (refer_tbl) with refer date and discharge date in it.

How would I calcualte the time between the 2 dates in days or months or even days and months together?

I also have another table (contact_tbl) and how would I calculate the time between refer date (from refer_tbl) and contact date (from contact_tbl)

Thanks
Will

 

[KenHigg]

I think the datediff() function may give you what you need.

 

[YNWA]

Sorted cheers. I used this

Expr1: DateDiff("d",[Refer Date],[Discharge Date])

This calcualtes between my two chosen fields, to calculate fileds put field names in [field name1] , [field name2]

I used "d" to do the calcualtion in days.

Hope this helps others.
Cheers

 

[KenHigg]

Cool - Glad you got it working.