Datediff problems in Report

[pbassett]

My Activities report lists several date fields: Start Date, Write-up Date, and End Date. I need to display the Aging of each Activity. This is simply the number of days since the Start Date. I entered the Control Source as
=DateDiff("d",[Start Date],Date())

For some reason this is not working, and the result is as if I entered
=DateDiff("d",[End Date],Date())
as the Control Source.

Apparently it's reading the Start Date wrong! Strangely, the calculation works correctly if I use Write-up Date.

Additionally, [Start Date] alone displays OK, but "=[Start Date]" displays End Date, so I think the equals sign is causing a problem! I tried
DateDiff("d",[End Date],Date())
but got a syntax error (no "=")

Any reason why the equals sign could cause a display error?

 

[Andrew Fergus]

Hi

It sounds like there is an issue with the naming of some of the fields within the report or in the underlying data source. While you are in the report design screen, select the start and end date objects on the form and check the 'Name' property of these objects - it sounds like one object might have the name of the other. This is entirely possible and results in the incorrect information being pulled into a calculated field on the report.

If this doesn't resolve the issue, is the report based on a table or a query? If the report is based on a query can you post your SQL? If the control source of the report is a query have you considered calculating the aging within the query instead to avoid issues with the naming of controls?

HTH, Andrew