ramaraju srinivas

ramaraju srinivas

  • NA
  • 22
  • 33.9k

Counting no of days between dates

Jul 28 2011 10:28 AM
Hi,
 I am working on leave module. we maintain all holidays related dates in holidaydatadase list . when leave is applied the start date and enddate is menctioned . so we need to count no of days between the start and end dates
 - holidays .

 For this i wrote a caml query

<Where><And><Geq><FieldRef Name='holiday'/><Value Type='DateTime'>" +FromDate  + "</Value></Geq><Leq><FieldRef Name='holiday'/><Value Type='DateTime'>" + Todate  + "</Value></Leq></And></Where></Query>"

holiday is a column in holidaydatabase list.

i am getting zero values when this query is executed
can any on help

Answers (2)