Using mthOfYr and year functions in where clause

(0) Share

Report

Posted on by maram fraij

I try to use mthOfYr and year functions in a where clause as explained below. When I compile the query the following error message is received (Illegal use of WHERE expression). How can I use these functions in a where clause?

select sum (Value) from SalaryCalcDetails where mthOfYr(SalaryCalcDetails.CalcDate)==1

&& year(SalaryCalcDetails.CalcDate)==2012;

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Martin Dráb 237,697 Most Valuable Professional on at

Like (0)

Report

RE: Using mthOfYr and year functions in where clause

You can't use X++ functions in SQL queries. Find first and last day of the month and use normal relation operators (>, <, =).

Or you could create a view with a computed column and there you can use T-SQL functions.

Was this reply helpful? Yes No
maram fraij on at

Like (0)

Report

RE: Using mthOfYr and year functions in where clause

ok, thank you

Was this reply helpful? Yes No
Martin Dráb 237,697 Most Valuable Professional on at

Like (0)

Report

RE: Using mthOfYr and year functions in where clause

Please verify the answer if you got what you needed.

Was this reply helpful? Yes No
maram fraij on at

Like (0)

Report

RE: Using mthOfYr and year functions in where clause

Yes I got it. Thank you

Was this reply helpful? Yes No