The below XML gives an errorÂ
Â
EXCEPTION Message: String was not recognized as a valid DateTime. ... Stack Trace: Â Â at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.PerformReplicationForTableAndPerson(String tableNameIn, String personIdIn, Boolean truncateTableIn, String deviceSequenceIn, SQLiteCommand sqliteCommandIn, mm_process_defRow syncRuleIn, Dictionary`2 tableColumnsDictionaryIn)
  at Metrix.BusinessServer.BusinessPolicies.SharedTablesComponent.MobileManager.PerformInitializeMobileDevice(String personId, String deviceSequence, String message, SQLiteConnection theSQLiteDB, Dictionary`2 theSyncRuleTableColumnsDictionary)
Â
<hierarchy_select return_only_requested_attrs="true" max_rows='50000'>
 <primary_table>PERSON_CAL_EXCEPT</primary_table>
 <from>
 <table>PERSON_CAL_EXCEPT</table>
 </from>
 <attrs>
 <attr>PERSON_CAL_EXCEPT.*</attr>
 </attrs>
 <where>
 <data_constraint>
  <constraint>
  <left_operand>PERSON_CAL_EXCEPT.PERSON_ID</left_operand>
  <operator>eq</operator>
  <right_operand>{PERSON_ID}</right_operand>
  </constraint>
  <constraint>
  <left_operand>PERSON_CAL_EXCEPT.END_DTTM</left_operand>
  <operator>gt</operator>
  <right_operand>@expression now()+days(-30)]</right_operand>
  </constraint>
 </data_constraint>
 </where>
</hierarchy_select>