Changing format of the date field to text string

  • Profile Image
    celsol 
    Asked on April 07, 2015 at 11:53 AM

    I have an issue with the date widget

    currently the variable is returned in format DD-MM-YYYY (09-04-2015)

    Ideally I need to return DD MMM YYYY (09 Apr 2015).

    I am not too bothered how it is displayed on the form just need that format on the notification as it will be used as the subject line for the notification email.

    I have seen something done on this page which come close: http://form.jotformpro.com/form/50884356788978?

    However am not sure how to implement, I am using the embed script and would prefer not to use raw HTML.

    Any advice would be appreciated.

  • Profile Image
    Charlie
    Answered on April 07, 2015 at 12:45 PM

    Hi,

    If you would like to output the date field just like the one shown in the sample form, you can follow the steps below.

    1. First, add the default date field in your form, in your case I assume you already have one. Add the "Form Calculation" widget and click the wizard icon to set it up.

    2. Inside the form calculation widget, use the dateString() function and add the date field inside it. This will convert the date field to a text format.

    3. Here's the list where you can find the dateString() function.

    4. Make sure to save the changes. After that, you can click the notification in your "Emails" setting.

    5. Inside the email notification, add the form field tag for the form calculation widget anywhere in your email. In this case I added it on the subject line.

    5. I made a test submission and this is who it will looked like in my email inbox.

     

    I hope that helps.

    Kind regards.

  • Profile Image
    tmi
    Answered on November 22, 2015 at 11:42 PM

    Hi Support,

    Can we format the calculated date.. i.e like dd-mmm-yy

    now, the output is showing day mmm dd yyyy format.

    we are trying to send the notification to some other system with due date in the subject. The other system is allowing to set due date in dd-mmm-yyyy format only.

    please advise.

    Regards,

    Krishna

     

  • Profile Image
    Charlie
    Answered on November 23, 2015 at 12:54 AM

    @tmi

    To better assist you, I went ahead and opened a separate thread for us to discuss the concern you have. Please refer to this link instead: http://www.jotform.com/answers/709905. We will address it accordingly.

    Thank you.