Issue with saving Date Criteria in the InforCRM Query Builder version

When creating a group in the Infor 8404 web client, I noticed an issue when using a date field in the query conditions.   Regardless of the date value selected, saving the condition results in the date value of 12/30/1899 being saved and used as the group condition.   This is obviously an issue depending on how you are using the condition in your group.

To demonstrate the issue, I’ve created a new group to display my test Accounts created before December 31, 2020.

Query Builder conditions

After including my date criterion it appears as though the date I selected is going to be saved:

However, the new group is not returning any data.  When I go back to edit the group, I see it is saving the incorrect date:

I’m not getting any records because I don’t have any Account records from 1899.

Fortunately, there is a workaround.  You can use the “Use value as literal” checkbox, and enter the desired date value in a YYYYMMDD format.  You do lose the date picker, but it will persist the value you enter:

Will save literal data


Entering the data in YYYYMMMDD Format and checking the Use Value as Literal checkbox will save the date entered.

Now I can see my test records.

Finally, a working group.

I should also point out that this doesn’t appear to be a problem in the LAN client; however any groups created in the LAN client will have the same issue when viewed in the WEB client.

This has been reported as an issue to Infor, so we should be able to expect a fix to this issue in the future.  In the meantime, use the Use Value as Literal setting to persist date-based criteria in the query builder.

Thanks for Reading!

Want content like this delivered to your inbox? Sign up for our newsletter!

Jason Buss

Jason is a senior application developer with Customer FX.

Submit a Comment

Your email address will not be published. Required fields are marked *