What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    How can I export Birth Date picker dates in the mm/dd/yyyy format?

    Asked by Venuspoledancing on August 27, 2014 at 02:05 AM

    I have a DOB date picker like so:

    But this seems to save the DOB in a string format like so:

    When I export it to import it into my Access database, it is not recognised as a date and cannot be saved. Is there any way to format this date in a more recognised date format for the export?

    format JotForm uploads png date picker date type date format export data
  • Profile Image
    JotForm Support

    Answered by jonathan on August 27, 2014 at 06:14 AM

    Hi,

    What format did you export it too? If you download the submission to an Excel file format, you can use the data format function of the Excel spreadsheet to change first the data format to Date type.

     

     

    After data are properly formatted to Date type, you can now import into your access database.

    Actually, to my knowledge Access also have the functionality to auto format the data into another type when imported. So, you may not need to do it in Excel and can directly just import it to your Access database.

    Hope this help. Inform us if you need further assistance.

    Thanks.

     

     

     

     

  • Profile Image

    Answered by Venuspoledancing on August 28, 2014 at 02:36 AM

    I had been doing it in CSV. But I have now tried in Excel format and I can't seem to get formatting to work in there either. I'm not sure what version of Excel you are using as mine looks different?

     

     

    I've also been looking everywhere for a way of formatting on import into Access, and I can only find people saying to import into a separate column and then run sql to format and put into right column, but that will not work as I need to be able to give this over to someone without any knowledge of sql (or even access in general, i need to make this as simple as possible).

     

    Any further help would be greatly appreciated.

  • Profile Image
    JotForm Support

    Answered by jonathan on August 28, 2014 at 06:30 AM

    Hi,

    In my screenshot I was using Google Spreadsheet.

    I was in the notion that it is easier to understand since it was also a spreadsheet. I apologize if you were confused instead.

    In any case, when doing it MS Excel application, the one you showed was also the method I will take. That is using the CSV data file.

     

    Unfortunately this seems to be the shortest process to take if you want to import the data to MS Access.

    --

    An alternative I can suggest, which I think will take the shortest route to import the data to your MS Access DB is to use Excel Macro to automate some process within the Excel file data.

    Use macro to auto convert the dates field to mm/dd/yyyy.

    I think you can already use ODBC connection string between Excel and MS Access.. it just needs the Jet driver or ODBC driver -- you can connect the Excel and MS Access this way.

    Hope this help. Please don't hesitate to inform us if you need further assistance.

    Thanks.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

  • Profile Image

    Answered by Venuspoledancing on August 29, 2014 at 04:56 AM

    Ah it's google spreadsheet! No strangely the format to date works there. But it doesn't in Excel. I guess the Microsoft date formatting is the same for Excel and Access though. Hopefully this will be sufficient. Thank you for your help.

  • Profile Image
    JotForm Support

    Answered by KadeJM on August 29, 2014 at 10:24 AM

    On behalf of my colleague who was assisting you here you are very welcome. If you have any new questions or problems please feel free to reach out to us again.