Page 1 of 1

date format

Posted: Sat Feb 13, 2021 4:04 pm
by jds
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?

Re: date format

Posted: Sat Feb 13, 2021 5:20 pm
by nageswaragunupudi
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()