Fetch the data from Date and Time Calculated column

Question

I am trying to fetch the result from list based on 3 conditions( Month Name,Employee,Department).

In my SharePoint List(Month Name is calculated column fetching month from column "Joining Date") .

Below is the caml query trying to get fetech the value using column(Month Name) but found no luck.I had gone through the internal of the column "Month Name" and I see "Month" as internal name

can any one help me in knowing what went wrong in below code

var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml("<View><Query><Where><And><Eq><FieldRef Name='Employee'/><Value Type='Text'>" + Employee + "</Value></Eq><Eq><FieldRef Name='Department'/><Value Type='Text'>" + Department+ "</Value></Eq><Eq><FieldRef Name='Month Name'/><Value Type='Calculated'>" + monthname+ "</Value></Eq></And></Where></Query></View>")

Answer 1

You can only nest two Eq directly in one And statement, so you need to add another And statement, like this:

var camlQuery = new SP.CamlQuery();
camlQuery.set_viewXml("<View><Query><Where><And><Eq><FieldRef Name='Employee'/><Value Type='Text'>" + Employee + "</Value></Eq><And><Eq><FieldRef Name='Department'/><Value Type='Text'>" + Department+ "</Value></Eq><Eq><FieldRef Name='Month Name'/><Value Type='Calculated'>" + monthname+ "</Value></Eq></And></And></Where></Query></View>")