import with format date

PHPMaker General Discussion (PHPMaker)
1

how can use import format date example excel.
invoice month company
109091 7/6/1991 AAN
30000 7/7/1991 AAN
table:
id bigint primary
invoice bigint
month date
company varchar
import success but field month export 0000-00-00can anyone help?
thanks

2

Use Row_Import server event (see Server Events and Client Scripts in the help file) to change the date to the date format of your project.

3

any clue export date

whether to use the phpspreadsheey library?

4

You may override the exportValueBy() method of the ExportExcel5 class (from the PHPExcel extesion), similar to https://discourse.hkvstore.com/t/phpspreadsheet-and-titles/723/1

5

how to get excel data before storing it in a table?
thanks