Subject Re: date problem in appending from Excel From Ken Mayer <dbase@nospam.goldenstag.net> Date Thu, 4 Mar 2021 10:36:30 -0800 Newsgroups dbase.getting-started On 3/4/2021 10:32 AM, Emeka Ossai wrote: > Hello, > > I need your assistance.  I saved the file as a csv file. I am trying to append the data  from csv to dbase, but the date did not show at all. Other data showed except date. > > I used 'append from c:\bike\bikal.csv delimited' It is likely the date format needs to match what your current date setting is. If it doesn't match, dBASE won't know how to interpret the value, as it is really a string coming in from the CSV file. To see what your current setting is: ? set( "date" ) Compare the format against what is in the .CSV file. If it doesn't match: cOldDateFormat = set( "date" ) set date "new date format string" // see help (help set date) //perform the append ... set date &cOldDateFormat. // reset date format Ken -- *Ken Mayer* Ken's dBASE Page: http://www.goldenstag.net/dbase The dUFLP: http://www.goldenstag.net/dbase/index.htm#duflp dBASE Books: http://www.goldenstag.net/dbase/Books/dBASEBooks.htm dBASE Tutorial: http://www.goldenstag.net/dbase/Tutorial/00_Preface.htm