I am trying to build a CAML query for SharePoint 2007 environment, to get items from a calendar list. Want to query items with a given 'From date' and 'To date', the calendar list contains 'EventDate' and 'EndDate' in Datetime format. I am only interested in the date part of the datetime field.
How can I trim the "EventDate" DateTime field of Calendar list to just Date and compare?
Is there any other way to get this done apart from CAML.