i am using a formula in my subreport which goes like this:
'datediff("h",{VEHICLE.jo_datetime_created},{VEHIC LE.jo_datetime_released})
but when i try to run the system it has a run time error which goes like this:
This field name is not known. Error in File C:\DOCUME~1\AMALIN~1\LOCALS~1\Temp\VehicleEfficien cyByVehicleTypeWithBusinessGroup {2A589B55-85CD-4DBE-B90B-AF181A380C8C}.rpt: Error in formula . 'datediff("h",{VEHICLE.jo_datetime_created},{VEHIC LE.jo_datetime_released}) ' This field name is not known.
i am using the same formula in my other subreports, just a different data field, but it seem to work, why can't this work?
what could be wrong with this? I checked the database values for such fields and they seemed okay.
any help, please????