"field name is not known" error in crystal report

[arme9867]

i am using a formula in my subreport which goes like this:

'datediff("h",{ VEHICLE.jo_date time_created},{ VEHICLE.jo_date time_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\AMA LIN~1\LOCALS~1\ Temp\VehicleEff iciencyByVehicl eTypeWithBusine ssGroup {2A589B55-85CD-4DBE-B90B-AF181A380C8C}.r pt: Error in formula . 'datediff("h",{ VEHICLE.jo_date time_created},{ VEHICLE.jo_date time_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????

[MrMancunian]

Did you notice the white space between datetim and e_released???

'datediff("h",{VEHICLE.jo_datetime_created},{VEHICLE.jo_datetim e_released})