home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.paradox      To crash or not to crash, asks Borland      9,834 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 8,558 of 9,834   
   Don to All   
   Importing two digit year comma delimited   
   25 May 07 18:48:17   
   
   From: donn@princetonair.com   
      
   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.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca