Hi,
I am trying to find all the child records where the date field is not in sync with the parent's date field. Both the date fields are kept in sync all the time but some of the legacy data isn't. So, I tried advanced find but soon noticed there isn't 'Does not Equal' operator for date fields. I tried writing a sql query and convert it into fetchxml using xrmtoolbox but that isn't working either. I am getting the date-time format for the [datefield] is invalid or value is outside the supported range.
here is the xml that I converted from sql query which is causing the above error:
<fetch mapping="logical" version="1.0">
<entity name="incident">
<attribute name="title" />
<attribute name="new_name" />
<attribute name="new_datetime" />
<order attribute="new_name" />
<filter>
<condition attribute="new_datetime" operator="ne" value="new_datetime" />
<condition attribute="new_name" operator="eq" value="xxxx" />
</filter>
<link-entity name="new_details" from="new_eterid" to="incidentid" alias="B" link-type="inner">
<attribute name="new_cosname" />
<attribute name="new_datetime" />
</link-entity>
</entity>
</fetch>
Please let me know if there is a better approach or what could be wrong with my approach. Thanks for any help!
*This post is locked for comments
I have the same question (0)
