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 c
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 2-year
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 w
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 4D_Tec
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 t
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, a
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 pivot
7 matches
Mail list logo