What is the default date format for importing files?

Karen Price_dy086y

We trying to export data from a restore to another db. We have pulled the cvs file and the date data is correct, but on import, the dates are not coming out in the correct format and not the correct dates.

  What date format is the default that the system will convert to other display date formats?

Tim Perrault

Looking through the documentation, you should use the date format specified on the second step of the CVS import wizard. Specify the date format used in your CSV file using syntax that complies with the Java SimpleDateFormat.

 

If I go through the steps the default Date format is dd/MMM/yy h:mm a,  so my entry would be something like 28/OCT/21 9:47 AM