Jotform Cards: Date picker field's date format

  • Profile Image
    STMNGB
    Asked on March 08, 2018 at 07: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?

  • Profile Image
    gizem
    Answered on March 08, 2018 at 09: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.56


    The notification e-mail that I received:

    1520517614Screen Shot 2018-03-08 at 4.56


    Form's submissions page:

    1520517626Screen Shot 2018-03-08 at 4.57


    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.

  • Profile Image
    STMNGB
    Answered on March 08, 2018 at 09: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.jpg

  • Profile Image
    STMNGB
    Answered on March 08, 2018 at 09:34 AM

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

    1520519650Capture03_LI.jpg

  • Profile Image
    gizem
    Answered on March 08, 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.35

    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 

  • Profile Image
    STMNGB
    Answered on March 08, 2018 at 01:14 PM

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

  • Profile Image
    STMNGB
    Answered on March 08, 2018 at 01:15 PM

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

    1520532932Capture01.PNG

  • Profile Image
    Richie_P
    Answered on March 08, 2018 at 01: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.

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

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

    Let us know, so we can replicate the issue.

  • Profile Image
    STMNGB
    Answered on March 08, 2018 at 02: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.

  • Profile Image
    Victoria_K
    Answered on March 08, 2018 at 03: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.

  • Profile Image
    Victoria_K
    Answered on March 08, 2018 at 03: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.png

  • Profile Image
    STMNGB
    Answered on March 08, 2018 at 03:43 PM

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

    1520541775Capture01.PNG

  • Profile Image
    Adrian
    Answered on March 08, 2018 at 04: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.png

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

    1520546019awd.png

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

  • Profile Image
    STMNGB
    Answered on March 09, 2018 at 08:55 AM

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