CAML queries, SSRS, and datetime fields
I’ve been using Enesys Software’s product RS Data Extension to query data out of SharePoint 2007 lists in SQL Server (2005) Reporting Services. One quirk with the queries is that they use CAML and the dates must be in a particular format, ISO8601.
I wanted users to use the standard date-picker,...