Setting the Date Format in the csv flat file

Question

How to control the Date Format that is being used by JViews Gantt to load csv flat file?

Answer

To workaround this issue, you can explicitly specify in the csv file the date format that should be used when loading it.

Example of a csv entry (Activity Name, Activity ID, Start Date, End Date) without the date format:

Activity1,A1,2/25/04 10:21 AM,2/28/2004 10:25 AM,

Same csv entry with specified date format:

Activity1,A1,"MM/dd/yy HH:mm,02/25/04 10:21","MM/dd/yy HH:mm,02/28/04 10:25",

Same entry with semi-colon instead of comma:

Activity1;A1;MM/dd/yy HH:mm,2/25/04 10:21;MM/dd/yy HH:mm,2/28/2004 10:25;