calculating between 2 date fields

[wort0987654321]

i have two fields that contain to date records

i want to be able to add up the total amount of days that there have been between the 2 dates

anyone help?

 

[GumbyD]

[DateField1]-[dateField2]

GumbyD

 

[wort0987654321]

i am asked to enter the date to and from when i enter this information.

i want the report to jest calculate the amount of days

 

[GumbyD]

If you want it to calculate the difference in days on the report and you have the two date fields on the report, then you can just subtract the earlier date from the later date in a new text box. In a new text box go to properties > Record Source and type

=[Your Later date field name]-[Your earllier date field name]

That should display the number of days between the two dates.

GumbyD

 

[wort0987654321]

cheers