I have a list called
employees and it has a column named
Birthday. I have to campare if today is birthday,
how can I query in this way:
DateTime Date = DateTime.Now; SPQuery = new SPQuery(); query.Query = "<Where><Eq><FieldRef Name='Ditlindja' />" + "<Value Type='DateTime'>" + date + "</Value></Eq></Where>";
this code is not working with string type it works but not with DateTime why?