Does your query look like this QUERY([Table];[Table]Date_Field<=!1919-12-31!)
or this QUERY([Table];[Table]Date_Field<="12/31/19") Using a string can cause issues with date interpretation. If you are showing 4 digit years and you query using a date constant and get the wrong results, maybe check your data file in MSC. John DeSoi, Ph.D. > On Jan 18, 2020, at 8:13 AM, Eric Naujock <[email protected]> wrote: > > I am actually searching against a date field. Using the query function. This > is causing the dates before 1920 to not show up. I wound up finding them by > splitting the dates up into components and then querying against the integer > components. ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
