Trouble using datediff function

G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DateDiff function throwing error in Where clause 7
Can't query DateDiff 3
No results using DateDiff 5
Calculate No. Days between two dates 4
Adding the Total Days Generated by the DateDiff Function 4
Q: Appending crosstab query having dynamic variables 1
Setting the display format of a query using the DateDiff function 6
DateDiff on blank fields? 4

Top