Using mthOfYr and year functions in where clause

(0) Share

Report

Posted on by maram fraij

11,873

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

All responses (4)

Answers (1)

maram fraij 11,873 on at

Like (0)

Report

RE: Using mthOfYr and year functions in where clause

Yes I got it. Thank you
Martin Dráb 230,445 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.
maram fraij 11,873 on at

Like (0)

Report

RE: Using mthOfYr and year functions in where clause

ok, thank you
Verified answer

Martin Dráb 230,445 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.