Subject Re: date problem in appending from Excel From Gaetano D. <gaetanodd@hotmail.com> Date Sun, 7 Mar 2021 17:56:18 +1000 Newsgroups dbase.getting-started > > 3. select the date data type, then look for the predefined formats in > the right pane. If none of them suits, you can specify your own format > using y for year, m for month...etc., e.g. yyyy-mm-dd hh:mm:ss or > yyyy/mm/dd hh:mm:ss, then save/Ok that format. Repeat for every column > required, and save the file (don't use save as CSV, just hit the Save > icon) and close it. Open it in notepad and check that the format was > saved as expected, from there you can append from the CSV in dBase. > > > HTH > > Gaetano. > just to clarify: you need to select Custom data type to view or define custom date formats