Query GLENTRY by ENTRY_DATE

[Steve Carlton]

I am attempting to use the API and query using ENTRY_DATE date range, but I am getting an error:

<errormessage>
    <error>
        <errorno>DL02000001</errorno>
        <description>Error</description>
        <description2>There was an error processing the request.</description2>
        <correction></correction>
    </error>
</errormessage>

When I use WHENMODIFIED, the query works:

<filter>
    <between>
        <field>WHENMODIFIED</field>
        <value>01/01/2023 00:00:00</value>
        <value>12/31/2023 23:59:59</value>
    </between>
</filter>

But, this does not work:

<filter>
    <between>
        <field>ENTRY_DATE</field>
        <value>01/01/2023 00:00:00</value>
        <value>12/31/2023 23:59:59</value>
    </between>
</filter>

Am I really not able to query using ENTRY_DATE?

[Steel, Mark]

Hi Steve,

Thanks for your post. 

If you don't receive a response soon, try posting in the relevant product forum as it may not be clear which products and API's your post is in reference to.

Thanks

Mark