Setting the Date Format in the csv flat file

Article ID: 2425
Last updated: 29 May, 2018
Article ID: 2425
Last updated: 29 May, 2018
Revision: 3
Views: 554
Posted: 16 Apr, 2012
by Dean J.
Updated: 29 May, 2018
by Gargani A.

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;

This article was:   Helpful | Not helpful
Report an issue
Article ID: 2425
Last updated: 29 May, 2018
Revision: 3
Views: 554
Posted: 16 Apr, 2012 by Dean J.
Updated: 29 May, 2018 by Gargani A.
Also listed in


Others in this category