What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Submission Dates Format In Reports In US format - All My Clients Want UK Format

    Asked by markashton on October 10, 2013 at 10:26 AM

    Submission dates in reports are one format only - Year-Month-Day

    All my clients want Day-Month-Year

    Can you advise me how to do this please

    Thanks

    Regards Mark

    Reports format thanks
  • Profile Image
    JotForm Support

    Answered by KadeJM on October 10, 2013 at 11:42 AM

    Heya Mark, I understand what you are referring to in regards about this.

    In the US our Date Format is set as " MM/DD/YYYY "  whereas in Europe (including the UK) it's more common to have the Date Format as " DD/MM/YYYY " in example as you've mentioned. 

    To my knowledge the only thing that is fully controllable as of right now is the Date Field which has an option to set it to the UK Format. However, in regards to the Reports you can actually make this work with the use of the Date Field by just unchecking the " Submission Date " so that it's not displayed. This will let the Date Field show in your Report thus displaying the UK Date Format that you want. I think this is a good way to have full control over it in your Reports. 

    Examples Grid Reports using this:

    (A) Grid Report with Submission Date: https://www.jotform.com/grid/32824635941054

    (B) Grid Report with Date Field set to UK Format: https://www.jotform.com/grid/32824477067057

     

  • Profile Image

    Answered by markashton on June 23, 2014 at 07:58 AM

    Hi,

    I have been using this workaround for some time. 

    Although not the end of the world ... it has a couple of drawbacks ...

    1) It is convoluted, to say the least, to have to add a field ... hide it, etc

    20 If the person stays on the form a long time ... the hacked date field sticks on its initial value, and therefore there is a significant discrepancy between the "true" submission date and date stamp from our hidden field.

    Could I suggest that the submission date in reports have a "date format" option ... instead of this cumbersome "hack" thing we have going on?

    Thanks mark 

  • Profile Image

    Answered by markashton on June 24, 2014 at 05:17 AM

    Could I have a response to the suggestion ...

    "When one sets up a grid report, one gets the option to choose the date format that the grid report uses".

    This is a feature request ... I would have created a separate thread but it relates to this thread entirely ... and one that I started.

    Can you advise me please?

    Regards Mark

  • Profile Image
    JotForm Support

    Answered by Welvin on June 24, 2014 at 06:02 AM

    Hi Mark,

    I have this thread forwarded to our developers as a feature request. I know this is important to you or to some other users, but the possibility of having this feature is always up to our developers. So again, there's no guaranteed timeframe of the implementation. Of course, we will update you via this thread for any progress.

    Thanks

  • Profile Image

    Answered by markashton on July 01, 2014 at 11:41 AM

    Hi Welvin,

    So, what did the developers say?

    Thanks Mark

  • Profile Image
    JotForm Support

    Answered by Welvin on July 01, 2014 at 11:54 AM

    This feature request is already assigned to our developer. There's no update yet, but the priority of this request is high.

    Thanks

  • Profile Image
    JotForm Support

    Answered by Welvin on July 01, 2014 at 11:56 AM

    Allow me to ask the assigned developer. I'll get back to you as soon as possible.

    Thanks

  • Profile Image
    JotForm Support

    Answered by alp_deniz on July 11, 2014 at 07:36 AM

    Hello Mark,

    I have looked for possibilities to complete your request and noted down a way to get it done. However, I will need some time to talk this subject with our team as it may require some changes in the overall structure. 

    Thank you

    Best

  • Profile Image

    Answered by markashton on September 16, 2014 at 11:37 AM

    @alp_deniz

    Did you get to have that chat ;-)

    Thanks Mark

  • Profile Image
    JotForm Support

    Answered by ashwin_d on September 16, 2014 at 12:54 PM

    Hello Mark,

    Unfortunately I do not see any update form them yet. 

    Let me send a note to @alp_deniz. He will get back to you as soon as he is available.

    Thank you!

  • Profile Image

    Answered by markashton on September 25, 2014 at 04:39 AM

    @alp_deniz

    You're obviously less available than Barack Obama at this time then?

    I think it would be a good idea for the submission date time stamp to map to that used in the country.

    My clients want/request the submission date in Day-Month-Year.

    Possible to get this done ... just the format please ... nothing else.

    Regards Mark

  • Profile Image

    Answered by jedcadorna on September 25, 2014 at 07:56 AM

    Hi Mark,

    Alp received your message, but I'm not sure when this request will be implemented. Hopefully, you'll get a response here soon.

    Thank you for your patience.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on September 28, 2014 at 12:42 PM

    Hello Mark,

    I have just started integrated user-specific time formats on your request.  It took some time to re-focus due to my other active projects. Please accept my apologies.

    I will update here when users are able to select their own format to decide their time representations. Thank you very much for your input.

    Kind regards

  • Profile Image

    Answered by markashton on September 29, 2014 at 10:56 AM

    @alp_deniz

    That's great news. Am I correct in understanding that a user will be able to choose the date format for submission dates that show in Grid reports, RSS feeds etc?

    Currently in jotformk it is limited to: 2014-09-27 05:18:03

    UK preferred format is: 27-09-2014 05:18:03

    Look forward to the ability of being able to choose the format for submission date.

    Thanks Mark 

     

  • Profile Image
    JotForm Support

    Answered by KadeJM on September 29, 2014 at 11:06 AM

    Hey mark sorry about that, but I think what he meant was he was busy with previous projects and has now started to refocus on your request here since he stated that he has started to implement this.

    I believe you will start to see this implemented so you might notice some changes and our dev will update you as soon as he can once he's completed it.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on September 30, 2014 at 02:12 AM

    Hello Mark and Kade,

    Good news, this has just gone live! Please let me know if you experience any issues or inconsistencies.

    All the best,

  • Profile Image

    Answered by markashton on September 30, 2014 at 06:14 AM

    A touch of jotform genius ;-)

    Just one thing folks ... you have to change the time format in your jotform settings to the one you desire .... click on the top right corner where there is the little icon ... click on Account ... and you can change your time format there.

    Results ... your submission dates will be in the time format you desire e.g. grid reports etc.

    @alp_deniz

    Thanks man ... wicked