Is there a date picker that allows the DDDD, MMMM D, YYYY format?

  • Profile Image
    NicolCorcExpo
    Asked on August 25, 2019 at 05:17 PM
  • Profile Image
    jherwin
    Answered on August 25, 2019 at 06:03 PM

    Please check my demo form here and see if that could work for you: https://form.jotform.com/92366932100957

    If yes, you can achieve that by following the screencast I made below:
    1566770469date.gif

  • Profile Image
    NicolCorcExpo
    Answered on August 25, 2019 at 06:19 PM

    Thank you! I went ahead and tried that and unfortunately, the year kept getting garbled and I wasn't able to get the full day or month name. I took a look in the calculation to see if they had a text function (like in Excel) that would force it to display correctly, but it doesn't. I was thinking like TEXT(date,"dddd, mmmm d, yyyy").

    I appreciate your help. I'm probably just going to have a text box with the sublable explaining how it should be written out.

    Thanks again!

  • Profile Image
    jonathan
    Answered on August 25, 2019 at 07:04 PM

    In our colleague's test form, he uses the Calculation widget DateString function to convert the Date Picker field value to the long text date format 

    1566774071zzz 2019-08-26 06.59.11.png


    Please tell us your form link that have the Date Picker field in which you need the date value to be in long text format. We can assist you add this option on your form.

    Let us know if you need further assistance.



  • Profile Image
    NicolCorcExpo
    Answered on August 25, 2019 at 08:05 PM

    Thank you! I went ahead added the date string back in and it seems to be working as previously described by jherwin. this is the form that I'm working on. As you can see on the bottom of the form, I'm using the form reponses to create merged language that can be used later. I just want to make sure that I can have the fully formatted text in that merged language. If it can't be accomplished through the date string calculation, I think I'll just have a text field and ask the user to type out the full date. I would prefer to have them select from a calendar, however, in order to avoid errors.

     

    Here is my form: <<removed for privacy>>

    Thank you again!

  • Profile Image
    roneet
    Answered on August 25, 2019 at 10:48 PM

    I believe you are referring to this date functionality:

    15667876211.PNG

    It seems to work correctly. Let us know if you experience any issues with it. We will be happy to take another look.

    Thanks.


  • Profile Image
    NicolCorcExpo
    Answered on August 26, 2019 at 08:46 AM

    Hi @roneet, thank you. Yes, the year is correct (I'm not sure what was happening the first time I tried this). At any rate, I'm needing the date to appear as Monday, August 26, 2019 instead of Mon Aug 26 2019 though.

    If it can't be accomplished through the date string calculation, I think I'll just have a text field and ask the user to type out the full date. I would prefer to have them select from a calendar, however, in order to avoid errors.

    Thank you! I appreciate your help!

  • Profile Image
    Welvin
    Answered on August 26, 2019 at 10:03 AM

    I'm sorry, but it is not possible in the DateString function. I tried looking for a workaround, but I cannot seem to get it to work. 

    You can have a text field, but that would give you an issue when people type out an incorrect date. It is just the short text, I'm sure people would understand the DateString result.