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

    The ability to set date format in Grid Report (yyyy/mm/dd)

    Asked by vrsioffice on September 01, 2013 at 11:01 PM

    You have added the date format yyyy/mm/dd to the Jotform form creation, which is great.  Thank you. 

    The reason I requested this format added was to allow reports to sort correctly by date.  (If a table or grid reports sorts by mm/dd/yyyy it does not sort in the correct date order, all months sort together regardless of the year.)

    However it seems that the change you implemented to the report creation has not carried over to the reports.  Grid & table reports are not picking up the new date format.  They are still sorting with the date format mm/dd/yyyy.

    I have created new reports, but I get the same result.

    Example see: http://www.ncsathletics.org/scores.htm

    Thanks,

    Julie

    Page URL:
    http://www.ncsathletics.org/scores.htm

    Reports form creation JotForm table
  • Profile Image
    JotForm Support

    Answered by Welvin on September 02, 2013 at 05:44 AM

    Hi Julie,

    Good day! Unfortunately, we do not have the ability to set date format when creating grid reports. Let me add this thread to our Feature Request List.  However, I cannot assure you anything about this request. You should be notified if something like this will be added.

    While waiting, you may consider this workaround:

    1. Add the DateTime Field into your form, be sure that "Default Time/Date" is ON

    2. Set the field Format as YYYY/MM/DD, see screenshot:

    3. Hide this field using Custom CSS codes that will be injected to the form

    Example output form: http://form.jotformpro.com/form/32442494832961?

    Example Grid Report output: https://www.jotform.com/grid/32442441957052

    This should work for you. You may have to use another form to apply this workaround.

    Thanks

  • Profile Image

    Answered by vrsioffice on September 02, 2013 at 09:05 PM
    I am not sure what you mean by “Hide this field using Custom CSS codes that will be injected to the form”. I do want date info to show on Grid report.

    Julie



  • Profile Image

    Answered by vrsioffice on September 02, 2013 at 09:18 PM
    I figured it out. I had to go into the submissions section and re-submit all the entry to get the new date format to show in the grid and table reports.

    Thanks,

    Julie

  • Profile Image
    JotForm Support

    Answered by Welvin on September 02, 2013 at 10:54 PM

    Hi Julie,

    Glad that you have it sorted. Let us know if you need any further assistance for this function. 

    Thanks