How to search objects using simple query with date parameter

[former_member399424]

Dear Experts,

As you know that in order to get all the object details both in ESR & ID we use simple query as below.

http://host:port/dir/support/SimpleQuery

I am not able to customize the search using date option like i need to find out what all the objects moved to production in a defined period.

I tried all possible date formats but nothing worked out, for all the date format i tried i am getting the below error.

Invalid type 2015011 for field MODIFYDATE(com.sap.aii.utilxi.sql.api.Tablefield@65256768)

Could someone help me how do we customize this search based on date.

Thanks in advance.

Regards,

Mohammed Farooq

[iaki_vila · Accepted solution]

Hi Mohammed,

I can't get to work with between clause, but with GT or LT, the format is for example:

#DT#2004-02-12

Regards.

[former_member399424 · Accepted solution]

Hi Inaki,

Thanks for sharing the data format.

I tried using the same format for between clause but no luck.

Regards,

Mohammed Farooq

[justin_santhanam · Accepted solution]

Mohammad,

I could able to get it work with the below format.

Thank you,

Justin.