I'm using Pdox9, plus 1,2,3SP's, on WinXP prof.
The .csv dates are "04/01/07".
After importing, I get 4/1/1907 or 4/1/0007 (am importing from 2 files, one
having field names in first row of data).
I am importing using the Import Data feature and not the Text Expert feature
b/c the files have 125 fields.
Win XP short date format is 4/1/2007.
BDE 5.01 settings are: 4 digit yr = TRUE; LeadingZeroD = FALSE; LeadingZeroM
= FALSE; Mode = 0; Separator = /; YearBiased = TRUE.
Is there a way to get a 2007 year after importing?
Thanks.

sure.. scan the table and change it.. that might seem like a flippant answer
at first, but over time you'll find out that not every import value is
perfect.. changing and/or correcting is part of the game..

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales

Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Sports Memorabilia and Trading Cards

Don

I think your Four Digit Year setting should be false. From the help file
-----------------------------------------------------------
FOURDIGITYEAR
Determines how the BDE treats the century portion of a date when only the
last two digits of a year are specified. If set to FALSE, the century part
of the date's year is added automatically based on its relative position in
a baseline range. If the date falls between 01/01/00 and 12/31/49, the year
is considered to be in the 21st century (05/20/22 becomes 05/20/2022). If
the date falls between 01/01/50 and 12/31/99, the date is considered as
being in the 20th century (12/08/98 becomes 12/08/1998). A TRUE setting has
no effect on dates expressed with a century (the year of a new date of
12/30/1902 remains 1902).

If set to TRUE, the year for the date is assumed to be literal (no century
digits automatically prefixed to the date). For example, a date expressed as
07/72/96 is considered to be the year 96 (0096).

FOURDIGITYEAR has an effect in such places as date literals in SQL
statements.

Default value: FALSE.
--------------------------------------------------------

HTH - Rick

"Don" <donn (AT) princetonair (DOT) com> wrote

"Rick Rans" <rick.rans (AT) canada (DOT) com> wrote:

I changed only the FOURDIGITYEAR to FALSE & now a 01/01/07 comma delimited
date imports as an alphanumeric 01/01/07. After changing the field to a Date
format, it appears as 1/1/2007.

Which Help file did you use? I couldn't find your text in Pdox9 Help.

Thanks much for the assistance.

Don

The help file in BDE administrator. When looking at the System-> Formats ->
Date settings just press F1 for help.

Rick

"don" <donn (AT) princetonair (DOT) com> wrote