Hi Team,

NotifiedDate is a date column in sharepoint list.

How to get the items using caml query for the below condition.

If(NotifiedDate>7 days && NotifiedDate <=30 days)

{

//Need to get these records form list

}

Regards,

Dhayanand

Hi,

Per my understanding, you might want to write a CAML query statement to filter by date range.

The code demos in the similar thread below would be helpful:

http://sharepoint.stackexchange.com/questions/42592/date-ranges-in-caml-queries

Another two demos for your reference:

https://dhondiyals.wordpress.com/2010/07/27/caml-query-search-between-two-date-ranges-sharepoint/

http://www.codeproject.com/Articles/414414/SharePoint-Working-with-Dates-in-CAML

More information about CAML query schema:

https://msdn.microsoft.com/en-us/library/office/ms467521.aspx?f=255&MSPPError=-2147217396

Thanks                 

Patrick Liang