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

  • NicolCorcExpo
    Asked on August 25, 2019 at 5:17 PM
  • jherwin
    Replied on August 25, 2019 at 6: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 Screenshot 10

  • NicolCorcExpo
    Replied on August 25, 2019 at 6: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!

  • jonathan
    Replied on August 25, 2019 at 7: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 Screenshot 10


    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.



  • NicolCorcExpo
    Replied on August 25, 2019 at 8: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!

  • roneet
    Replied on August 25, 2019 at 10:48 PM

    I believe you are referring to this date functionality:

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

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

    Thanks.


  • NicolCorcExpo
    Replied on August 26, 2019 at 8: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!

  • Welvin Support Team Lead
    Replied 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.