- markashtonAsked 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
- KadeJMAnswered 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
- markashtonAnswered on June 23, 2014 at 07:58 AM
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?
- markashtonAnswered 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?
- JotForm SupportWelvinAnswered on June 24, 2014 at 06:02 AM
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.
- markashtonAnswered on July 01, 2014 at 11:41 AM
So, what did the developers say?
- JotForm SupportWelvinAnswered 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.
- JotForm SupportWelvinAnswered 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.
- alp_denizAnswered on July 11, 2014 at 07:36 AM
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.
- markashtonAnswered on September 16, 2014 at 11:37 AM
Did you get to have that chat ;-)
- JotForm Supportashwin_dAnswered on September 16, 2014 at 12:54 PM
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.
- markashtonAnswered on September 25, 2014 at 04:39 AM
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.
- jedcadornaAnswered on September 25, 2014 at 07:56 AM
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.
- alp_denizAnswered on September 28, 2014 at 12:42 PM
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.
- markashtonAnswered on September 29, 2014 at 10:56 AM
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.
- KadeJMAnswered 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.
- alp_denizAnswered 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,
- markashtonAnswered 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.
Thanks man ... wicked