where clause not working with AND operator

Question

Hi,

fetching data from Sharepoint online , to shoe data on asp.net page.

Problem : Where clause not working with And operator to fetch records , based on date.

Solution Required: I need to know , how or what to write in query to fetch data accordingly.
attached image is added for reference.

Thanks

Answer 1

Hi @Mohammad Qasim ,

The DateTime in SharePoint needs to be in specific format : yyyy-MM-ddTHH:mm:ssZ. The variable dtexppiry should be configured like the below:

string dtexppiry=DateTime.Today.ToString("yyyy-MM-ddTHH:mm:ssZ");   

---

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.