Forms Datetime control does not display 24h mode

Hi Michael, are you using o365 or on prem?  You should be able to get 24 hour display format with your on-prem instance.  Just make sure to set the site regional settings to use 24 hour time.

o365 on the other hand might need to be a UserVoice request.

Cheers,

Chris

Hi,

also on o365 you could change your site regional settings to use 24hour time

Giacomo

Hi Chris,

 I am working On-Premise. I went ahead and changed the Regional Site Settings to 24 hour time but, the Date Time control still displays in 12 hour AM/PM. I went into the interface and did a drag and drop of a new Date Time control but it still looks the same. Am I missing something? Do I need to wait an amount of time before the setting gets refreshed to the site?

Screen shot of settings change and control:

Thanks for your help,

Mike

Hi Mike,

I'm not sure what's going on here. To test further, I created a brand new subsite and made sure it was in 12 hour format.  I then created a new list, created a date/time field and created a responsive form.  The form used the 12 hour format.

I then changed the site regional settings to 24 hours and everything automatically changed to use the 24 hour format.  I didn't need to republish the form or anything.

When you change from 12 to 24 hours, do the dates in your list change to the 24 hour format too?

Cheers,

Chris

Hi Giacomo,

Changing the site regional settings in o365 didn't make any difference for me.  I tried it in two tenants and used different regional settings (US and NZ) and the form controls still use a 12 hour format.  Changing the regional settings in on-prem does work though.

Hi Chris,

sorry, you're right! It looks like that the control is rendered based on the default time settings of that regional settings..if you switch, for example, to English (Ireland) that allows only 24h time, then the control is rendered in 24h format..

Hi Chris,

 I went ahead and connected the "Date Time" control to a column that I created that was a Date Time column. The "Date Time" control in the form still shows in 12hour format. When I pick a date and time and save the form, the list column is updated and the list column shows in 24hour format.

 My problem isn't that I can't get the SharePoint list column to show in 24 hour format because it does show correctly. My problem is with the Date Time control on the User form still displays in 12hour format. Even when it is connected to a list column that is in 24hour format it still displays on the form in 12hour format.

Thanks again for all your help with this,

Mike

Hi Mike,

Yep - I was just checking to make sure your regional settings were indeed saving/displaying in 24 hour format on the SharePoint level.  For some reason Nintex isn't replicating this and I'm scratching my head as to why.  Are the regional settings I posted above the same as yours?  i.e. is yours in US format etc because maybe that makes a difference.  For the record mine are usually use the New Zealand timezone settings and they work fine too - I'm clutching at straws here.

Just to prove you and I aren't bonkers, here's my Nintex responsive form with date field rendered in 24 hour format

Here are the column and control configs.  Is there anything different for you?

I'm going to try that out.  Michael Brewis‌, maybe this applies to your situation too?

Hi Chris,

 My settings are almost exact. I am on Eastern Standard time US and English Untied States. I changed to English New Zealand but there was very little difference.

 I have also been trying to set the "Date Format" parameter of the control but with no success.

 My SharePoint environment is 2013 but it seems like your environment is similar as well.

Thanks for your help, looks like I will have to sideline this one for a bit and get back to it.

Mike

Something is strange here.  I changed my site regional settings to EST and 24 hours and it still displays correctly.  I even note that my local PC displays in 12 hour time (see the clock in the bottom left of the screen) which tells me the display is completely controlled by the server.  I did not need to touch any of the String Format settings - that field is blank.  Is that what you mean by "Date Format" parameter?

Cheers,

Chris

Hello Chris,

 I thought I would give you an update as to the solution to the problem. In the end we all decided that the Date control only needs to show the date and not the time. We then added 2 dropdowns one for hour and another for minutes. We will put the complete date time together in the backend workflow. Unfortunately the Date control never did display in 24 hour mode.

Thank you for your help,

Mike

Thanks for the update Mike.  I'm sorry we couldn't get to the root cause of this.  It'll be some cryptic server setting somewhere I reckon!

Cheers,

Chris