0021198: Due Date field and customised date fields are not imported

ID	Project	Category	View Status	Date Submitted	Last Update
0021198	Plugin - CsvImport	General	public	2016-07-05 03:53	2018-05-15 06:50

Reporter	mantisiator	Assigned To
Priority	urgent	Severity	block	Reproducibility	always
Status	new	Resolution	open
Platform	2.1.19

Summary	0021198: Due Date field and customised date fields are not imported
Description	I am currently using the Mantis 1.2.19 version. When trying to import a CSV file into Mantis, the preview is OK, but after import: the core "Due Date" field always remains empty, the customised Date fields are always set to 01-01-1970 (only the import into the core Date field "Date Submitted" is imported correctly)
Tags	No tags attached.

mantisiator 2016-09-01 04:03 reporter ~0053919	Hi, The problem has been identified in version 1.2.19 Since then, a new brach has been created for the 1.3.x versions. Can you please indicate if any action has been undertaken on that point in that new branch ? Thanks a lot in advance !

mantisiator 2016-09-01 05:11 reporter ~0053920	Hi, I finally found out the solution to the problem: The custom fields of Date type have to be imported in a specific format, ie number of seconds after 01-01-1970 in order to be imported properly.

mantisiator 2016-09-01 07:53 reporter ~0053921 Last edited: 2018-05-15 06:50	Hi, To be more precise, as complementary information if it can help in Excel, the following function is OK to have the number of seconds since 01/01/1970: `=("2009-02-13"-"1970-01-01")2460*60`