Filter on lookup date field

[rpierce]

Hello,

I have a child table that gets the date automatically from a parent table. When I attempt to filter records of the child table on date it does not work. For instance if I use a filter such as Date Greater than 01/31/2022, the results are all records. Is there a simple solution??

Please, and thank you for help.

Ray

[pbottcher]

Hi Ray,

I tried to reproduce your problem, but on my system it just works as expected and the filter can be applied correctly.
Maybe you can post some screenshots of your settings.

Do you have any code that works with the fields?

[rpierce]

Hello and thank you for replying.

No, I don't know of any code on the date field. It simply has the Auto Fill box checked. It is an Integer data type, length of 6, since it is a lookup. It is marked as Unsigned if that makes a difference?

[peebee]

What format is the date for the filtered field being stored in the database? Perhaps you need to filter using a format other than mm/dd/yyyy?

[pbottcher]

Hi again,

even with an autofilled field it just works fine. Can you post an image of your tableview and the filter you apply.

[rpierce]

I updated my version of AppGini and regenerated the app. Now it seems to be working just fine!? I was doing a simple filter; Date Greater than 12/31/2021 and received all records. But now things are working.