Trouble using datediff function

N

nacholibre

I'm calculating the difference between two dates (in months) and I am
receiving an 'enter parameter value' prompt when I try and run the query:

SELECT DateDiff([m],ODS_LMAS_CURR!CHRG_OFF_DT,ODS_LMAS_CURR!FUND_DT) AS Expr1
FROM ODS_LMAS_CURR
GROUP BY DateDiff([m],ODS_LMAS_CURR!CHRG_OFF_DT,ODS_LMAS_CURR!FUND_DT);

I'm being asked for a parameter value for 'm'

Others are able to run this same query without that prompt. Any ideas?
Thank you!
 
Top