Question

Date and time format Netherlands (24H)

0

Hi people, Could someone please point me in the right direction for the right date, time and date and time format for The Netherlands? Seeing as most of the people on this forum are dutch I hope someone can help me out :) I'm using the calendar widget which is amazing but the date and time formatting is completely off. I don't want to use the PM and AM time format in the Netherlands, clearly. Also, changing the language to Dutch is no option (I tried it before and some microflow text buttons messed up) FYI. I mean these fields: General settings: http://puu.sh/b2kF0/d2b824f793.png Calendar settings (if necessary): http://puu.sh/b2kHh/9b5fdf0d01.png Thanks guys!

asked 2014-08-21

Jaco van Gelder

9 answers

Erwin 't Hoen · Answer 1 · 2014-08-21

Date format would be dd-MM-yyyy Time format would be HH:mm:ss See here

Rom van Arendonk · Answer 2 · 2014-08-22

I believe these fields are formatted by the simple date format, which you can find here.

John Shott · Answer 3 · 2014-08-22

Jaco:

Disclaimer: I'm not one of the "high point count" folks who have been responding thus far ... I'm a comparative Mendix newbie ...

That said, if I am looking at the Shaw FullCalendar documentation properly, I think that you are interested in changing the property known as "axisFormat" under the set of Agenda properties.

http://arshaw.com/fullcalendar/docs1/agenda/axisFormat/

To the best of my knowledge, the current version of the Mendix calendar widget doesn't allow you to set that and export it to the underlying FullCalendar. I am tinkering with that at the moment because I believe that is not a wildly difficult thing to do. In fact, I'm also testing to see how hard it is to add the "slotMinutes" property (which is also not settable in the Mendix widget but is supported in the underlying Shaw FullCalendar. (Note: the Mendix Calendar widget current uses the default slotMinutes setting of 30 which determines the grid you see. If it were set to 15, it displays a calendar with 15 minute time increments.)

Good luck,

John

Jasper van der Hoek · Answer 4 · 2014-08-22

Make sure you change it in the Available views item. In your weekly view you need to specify the format. I just tested this and I no longer see am/pm (with a US locale)

Screenshot

Jaco van Gelder · Answer 5 · 2014-08-22

Thanks for the replies guys, i've gotten a little further.

The only problem I have left now is that in the calendar it still shows AM and PM, i can't get it out... I just want 00:00 to 23:59 on it

Here is what I mean : http://puu.sh/b39JC/b80a4937fa.png

Any ideas?

Jaco van Gelder · Answer 6 · 2014-08-22

Hi Jasper, thanks for the reply..

It really, really isn't working :( I changed it EVERYWHERE, including that tab. Here are my settings:

Extra tab: alt text

Appearance tab: alt text

General language settings formatting: alt text

Am I doing something stupid or is something not wanting me to change the format? haha :(

Jasper van der Hoek · Answer 7 · 2014-08-22

I just noticed that I wasn't testing with the latest version from the appstore.
Apparently the time format is broken in the latest version of the calendar widget. I just tried it myself with the latest appstore release, and I couldn't get it to work either.

I didn't release that my project is working with an old (unsupported) version of the calendar widget. Unfortunately you found a bug in the calendar widget.
Would you be able to enter a ticket for this problem? So our team schedule this to be fixed?

Jaco van Gelder · Answer 8 · 2014-08-22

Yes I can. No problem. Where can I add it?

But, what version are you using? I really want a version that works at this very moment because my app has to go live in a few days.

John Shott · Answer 9 · 2014-08-22

Jaco:

You should be able to enter a support ticket by going to world.mendix.com and clicking the "Support" button. I actually have an open ticket related to the latest Calendar widget (ticket number 102819).

While my issue was different (the "onChange" Microflow isn't called if you drag an existing calendar event from the end of the event to increase/decrease the duration but not the start of the event), I at least added a note describing the problem that you had seen in my open ticket and included at least one possible fix that addresses this issue.

While it is probably best for you to open a ticket for this specific issue, I at least wanted you (and Jasper) to know that there is at least one open ticket on the v 2.0.1 Calendar that mentions these issues.

I don't know what the typical turnaround time on ticket fixes of this type might be. While it is best to wait for the official fix and release, I could probably send you my own locally-modified Calendar.mpk file that (I believe) addresses this issue if you are in a bind and assuming that is a legal and proper thing for me to be able to do.

Good luck,

John