Time information does not have a separator in the imported data

  • CNSTradingLtd
    Asked on January 19, 2017 at 5:39 AM

    Hi

    I am using your Excel Import facility - import.jotform.io

    When I import an Excel Date Time field such as this 26/10/2015 16:28

    the contents of the Field in Jotform does not have the colon and looks like this 26/10/2015 16 28 

    Any ideas

    Thanks

    Robert

     

  • Welvin Support Team Lead
    Replied on January 19, 2017 at 7:11 AM

    I can see that. Would you mind letting us know how did you get the source file? Is it from another form? If so, please share us the excel file or the form URL so we can also check. You can send the file to support@jotform.com. Please don't forget to put this thread in your email as reference.

    I would also like to mention that when you edit the submission, the date is placed in the year box:

    Time information does not have a separator in the imported data Image 1 Screenshot 20 

    I will forward this to our developers, but I need to check the source file first for proper documentation.