How do I Work with Dates?

May 7, 2009 at 12:10 AM
With the LinqToCRM provider, how do I write a query that would return, for example, all contacts created on or after a certain date?  The fetchXML equivalent of

<condition attribute="createdon" operator="on-or-after" value="2009-05-01"/>

May 7, 2009 at 8:09 AM
You need to use the CrmHelpers which will augment the CrmDateTimes with "UserTime" properties. Then you should be able to a simple ">".

I realise the CrmHelper-requirement is not really optimal, and it would be great if someone could find time to hack something together specific for LinqtoCRM.