Substituting Date Values After Submission

  • JuliaIngram
    Asked on July 21, 2015 at 8:31 PM

    Hello, I was wondering if there was any way to replace a standard numerical date (ex. 8/16/2015) with one that is spelled out (ex. Wednesday, August 16) once it is submitted. Particularly, I have a checkbox type question with each option formatted as a spelled out date as the latter example, but I would like the submission to appear in the Google spreadsheet I have integrated submissions with in numerical format, either as a replacement for the spelled out format, or in a separate column as a response from another field.

    Basically, I want the form to look like this: Wednesday, August 16

    But the spreadsheet to say this: 8/16/2015

     

    Thank you!

  • Chriistian Jotform Support
    Replied on July 22, 2015 at 3:11 AM

    Hi JuliaIngram,

    Thanks for contacting us.

     

    As per checking, you can only format a Date field in your form to the following format as shown in the screenshot below.

    Substituting Date Values After Submission Image 1 Screenshot 30

    However, in the Google Spreadsheet, you can format the Date field column, just follow the instructions below:

    1. Highlight the Date field column.

    2. Click Number button.

    3. Click "More Formats" in the dropdown options.

    4. Click "More Date and Time Formats" option.

    5. Select the format you want to set to the column.

    Substituting Date Values After Submission Image 2 Screenshot 41

     

    Do let us know if you need further assistance.


    Regards.