FiveTech Support Forums

FiveWin / Harbour / xBase community
Board indexActive topicsAll discussionsLogin (GitHub)
Board index FiveWin for Harbour/xHarbour date format
jds
Posts: 124
Joined: Sat Dec 05, 2009 12:44 PM
date format
Posted: Sat Feb 13, 2021 04:04 PM

By converting an excel file to a dbase file the date field is switching to the american style (MM/DD/YYYY)
How to prevent or rectify this?

nageswaragunupudi
Posts: 10733
Joined: Sun Nov 19, 2006 05:22 AM
Re: date format
Posted: Sat Feb 13, 2021 05:20 PM

How are you converting Excel to dbf?
If you read excel data as a date value, you should not have any problem.
You may also consider using FWH built-in function FW_ExcelToDBF()

Regards



G. N. Rao.

Hyderabad, India

Continue the discussion

Static archive · New replies & topics via GitHub Discussions