Time information does not have a separator in the imported data

  • Profile Image
    CNSTradingLtd
    Asked on January 19, 2017 at 05: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

     

  • Profile Image
    Welvin
    Answered on January 19, 2017 at 07: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:

     

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