Import App: Submission date from the csv file is not being imported.

Hello,

After using the Import App to upload records from another source, the "Submission Date" of the imported records displays the date and time of the import, not the date and time indicated in the date column of the .csv file.

1. Is there a way to undo the import?

2. Will the Import App properly import records with an older date, or will it always set the submission date as the import date and time?

1. Is there a way to undo the import?

There is no way to undo submission import. The only possibility is to delete the submissions from your form's submission page. The following guide should help you how to delete submission:  https://www.jotform.com/help/377-How-to-Delete-Form-Submission-Data 

2. Will the Import App properly import records with an older date, or will it always set the submission date as the import date and time?

Can you please share the screenshot of one of the records you are trying to import and also the form in which you want to import the date? Do get back to us on this and we will take a look.

We will wait for your response.

Thanks for the helpful info on deleting just a particular set of data by date range.

Attached is a screenshot showing .xlsx data file header, and result, and a .csv file header, and result.

Is it possible for you send us the csv file to us? Please send the file to us in email at support@jotform.com and we will try to import it in your cloned form.

Please ensure the subject line of the email as "Thread #1656985"

We will wait for your response.

 I sent the email, at 11:06 AM, 14 minutes after getting your message.

I was unable to locate your email. However, the issue is most likely related to the formatting.

Excel converts dates into numbers, so this will not work properly for import unless you somehow convert dates to the text.

In CSV, the format must match the template format. Again, if you save it in Microsoft Excel, the format might be different.

Here is a default format example (using Notepad++ editor):

You can do a test import using the next file:

https://shots.jotform.com/mike/files/1656985.csv

Thank you.

Mike,

Thanks for the pointer. When I created the .csv file using a different application (Numbers, instead of Excel) and tested, it imported the date records as expected.

Is the issue resolved? 

If yes, please disregard this reply. Thank you.