Jotform Cards: Date picker field's date format

  • STMNGB
    Asked on March 8, 2018 at 7:22 AM

    Hello,

    I set up my account with correct time zone (London GMT), and correct time format (EU-Asia-DMY) but all submissions display dates in wrong format M-D-Y. How can this be corrected?

  • gizem
    Replied on March 8, 2018 at 9:09 AM

    I have tested our Date Picker field on my test form as you can see in the below screenshots.

    -Note that it is not possible to change the date format (mm/dd/yyyy) for Card Forms yet.

    1520517596Screen Shot 2018 03 08 at 4 Screenshot 10


    The notification e-mail that I received:

    1520517614Screen Shot 2018 03 08 at 4 Screenshot 21


    Form's submissions page:

    1520517626Screen Shot 2018 03 08 at 4 Screenshot 32


    Can you please clarify which section you are mentioning? According to your request, we can escalate your problem to our development team and we can open a feature request.

    We will be waiting for your response.

  • STMNGB
    Replied on March 8, 2018 at 9:28 AM

    The date picker in my form itself displays correct date format. However, on the submissions it comes up in a different format MM-DD-YYYY.

    1520519291Capture02 LI Screenshot 10

  • STMNGB
    Replied on March 8, 2018 at 9:34 AM

    Also another example - wrong format - YYYY-MM-DD

    1520519650Capture03 LI Screenshot 10

  • gizem
    Replied on March 8, 2018 at 10:39 AM

    I assume you are referring this form: http://www.jotformeu.com/form/72880612071352

    Before we escalate your problem to our development team, please can you share your date picker field's screenshot with us?

    I can see the field as seen below:

    1520523328Screen Shot 2018 03 08 at 6 Screenshot 10

    If you see a different date format, please let us know.


    I have split your second problem into another thread to prevent the confusion.

    You can follow it here: https://www.jotform.com/answers/1409107 

  • STMNGB
    Replied on March 8, 2018 at 1:14 PM

    The above is correct form and that's exactly how the form displays the data field.

  • STMNGB
    Replied on March 8, 2018 at 1:15 PM

    Apologies. The form displays the date as DD-MM-YYYY
    See screenshot below.

    1520532932Capture01 Screenshot 10

  • Richie JotForm Support
    Replied on March 8, 2018 at 1:46 PM

    I cloned your form, but when I viewed my date picker, we have a different format.

    Mine is MM/DD/YYYY, here is a screen shot.Jotform Cards: Date picker fields date format Image 1 Screenshot 30

    When I tested the submission, the format in the submission page is correct, it is the same as the format in the form.

    Jotform Cards: Date picker fields date format Image 2 Screenshot 41

    Did you change layouts and changed the format of your date picker?

    Let us know, so we can replicate the issue.

  • STMNGB
    Replied on March 8, 2018 at 2:01 PM

    I too just cloned this form to replicate your process, and oddly enough this action corrected both the original and the cloned forms. The date field now displays MM/DD/YYYY. However, this is not the correct format for UK. We still need DD/MM/YYYY please.

  • Victoria_K
    Replied on March 8, 2018 at 3:22 PM

    Thank you for cooperation and clarifications! 

    This thread will now be escalated to our developers as a feature request to have an option to choose the date format at Cards Layout. 

    Unfortunately, we can't give you the ETA, but please be sure that we'll keep you posted with updates on this issue.


    Meanwhile, please let us know if you need any other assistance with your JotFroms.

  • Victoria_K
    Replied on March 8, 2018 at 3:29 PM

    As to the date format shown on your Submissions Page, I suggest you to check your account's settings, because it can cause the date format YYYY/MM/DD:

    1520540966Screenshot 4 Screenshot 10

  • STMNGB
    Replied on March 8, 2018 at 3:43 PM

    I checked this setting before starting this thread. Please screenshot see below.

    1520541775Capture01 Screenshot 10

  • Adrian
    Replied on March 8, 2018 at 4:55 PM

    It is possible to fix the Date Format in the Submissions page only, but not in the Form Preview. This would need intervention from the developers.

    To fix the Date Format in the Submissions page, first change the Form Layout to All Questions in One Page.

    You can change the Form Layout by clicking SETTINGSSHOW MORE OPTIONS, scroll down, change the Form Layout to the desired layout.

    All Questions in One Page or Single Question in One Page.

    1515168630aqi Screenshot 10

    Then, in the Form Builder, you will have the option to choose a Date Format for the Date Field.

    1520546019awd Screenshot 21

    After this, change the Form Layout to Single Question in One Page again and the desired Date Format should display in the Submissions Page.

  • STMNGB
    Replied on March 9, 2018 at 8:55 AM

    Thank you for your support! This solution has resolved the issue.