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

    Date fields show time in Excel or CSV

    Asked by ScottBenson on May 20, 2015 at 04:31 AM

    Date fields are set up not to record times on form however when downloading as Excel or CSV times are shown in the fields.

    How do you remove the times being automatically recorded when the date field is set up on to choose the date

     

    Refer to screen shot of the Excel / CSV file of a form being completed and it shows date and time

     

    Page URL:
    http://www.jotformpro.com/form/51391978475975

    excel CSV shown
  • Profile Image
    JotForm Support

    Answered by Boris on May 20, 2015 at 07:41 AM

    Hello Scott.

    I'm afraid that this is the way our time picker works. It does show only the date in the cells of your Excel, but it captures both time and date.

    If you want only the date to be captured, I would recommend that you replace the current Time fields with our Date Picker widget.

    How-to-Add-a-Widget-to-your-Form

    Please try it out and let us know how it goes.