Re: Dates and 4 digit years.

2020-01-18 Thread John DeSoi via 4D_Tech
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

Re: Dates and 4 digit years.

2020-01-18 Thread Jeremy French via 4D_Tech
Hi Eric, Have you considered using a date display format that forces displaying a 4-digit year? I’ve avoid the 2-digit year date problem by always using the "internal date short” display format: it shows a 4-digit year. This way the user can clearly see what year is entered. There is no

Re: Dates and 4 digit years.

2020-01-18 Thread Eric Naujock via 4D_Tech
I did find the pivot date function. It was set to 19;20. I have reset it back to 19;85. The year the database was started. Though some cases do date well before then. But I am not going to roll that out until next week due to testing requirements. > On Jan 18, 2020, at 12:58 AM, Peter Bozek

Re: Dates and 4 digit years.

2020-01-18 Thread Eric Naujock via 4D_Tech
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. > On Jan 17, 2020, at 8:02 PM, John DeSoi via

Re: Dates and 4 digit years.

2020-01-17 Thread Peter Bozek via 4D_Tech
On Fri, Jan 17, 2020 at 10:33 PM Eric Naujock via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I am running with 4d V17R5 and am seeing some odd date behaviors. When I > search for a record with a date prior to 1921 I get all records in the > database. Though most of the records are have dates newer

Re: Dates and 4 digit years.

2020-01-17 Thread John DeSoi via 4D_Tech
I don't see how the pivot year could have anything to do with it - that just controls data entry when two digit years are entered. I don't have 17R5, but I don't see any problems with 17.3 or 18.0. Are you searching with date constants or using a string? John DeSoi, Ph.D. > On Jan 17, 2020,

Dates and 4 digit years.

2020-01-17 Thread Eric Naujock via 4D_Tech
I am running with 4d V17R5 and am seeing some odd date behaviors. When I search for a record with a date prior to 1921 I get all records in the database. Though most of the records are have dates newer than 1985. This is rather odd. I am not sure if this is due to 4D playing games with the