Search Parameter with date time

Hi Anhht

I guess the error is because of the = in your first query (after <)

<AML>
<Item type = "Part" action = "get" where="[Part].modified_on &gt; '2019-04-11T00:00:00' AND [Part].modified_on &lt;'2019-04-20T00:00:00'"></Item>
</AML>

Alternately, you can use below query also to get the expected results

<AML>
<Item type="Part" action="get">
<modified_on condition="between">2019-04-11T00:00:00 and 2019-04-20T00:00:00</modified_on>
</Item>
</AML>

Another Way

<AML>
<Item type="Part" action="get">
<modified_on condition="gt">2019-04-11T00:00:00</modified_on>
<modified_on condition="lt">2019-04-20T00:00:00</modified_on>
</Item>
</AML>

Thanks,

GK

Thanks so much @gkarasuser,

Can I ask you another question? Is that AML not support operator <= or "le" ?

By the way, I will try follow your answer. Thanks buddy.

Hi Anhht

If you want to use "le" or "ge" it should be like

<AML>
<Item type = "Part" action = "get">
<modified_on condition="ge">2019-04-11T00:00:00</modified_on>
<modified_on condition = "le">2019-04-20T00:00:00</modified_on
</Item>
</AML>

It is not working when we are giving it as attribute. 

Thank You

GK

Hi Anhht

If you want to use "le" or "ge" it should be like

<AML>
<Item type = "Part" action = "get">
<modified_on condition="ge">2019-04-11T00:00:00</modified_on>
<modified_on condition = "le">2019-04-20T00:00:00</modified_on
</Item>
</AML>

It is not working when we are giving it as attribute. 

Thank You

GK