Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have a Infopath form that contain a date picker.

I set the date picker's date format to be 'DD/MM/YYYY'.

When I preview the Infopath form, the date format is correctly displayed.

However, when I publish it as a web-based Inforpath form in the SharePoint library, the display become 'MM/DD/YYYY', which is not what I have set.

Appreciate any help rendered.

share|improve this question
    
Hi, might be this answer would be of more help? –  Gennady Vanin Novosibirsk Jan 25 '13 at 9:27
add comment

1 Answer

Both are correct formats according to different settings

Infopath is the client application rendering dates according to (client/machine/Windows) Regional settings set in Control Panel > Regional and Language Settings > Regional Options tab > Standards and Formulas > Customize * > Date tab in (in Customize Regional Options dialog window) > Short date format* which you can change by pressing Customize... or choosing from listbox options button there. See Fig.1.

Fig 1. Client machine regional settings (used by client Infopath forms)

Fig 1. Client machine regional settings (used by client Infopath forms)

Sharepoint shows dates according to (Sharepoint server site) Regional settings < Site settings (in Site Administration section) < Site actions, on ribbon, in browser:

  • < sharepoint_site >/_layouts/regionalSetng.aspx

which again one can set to whatever settings one would wish. Cf. Fig.2

Sharepoint site regional settings

Fig 2. Sharepoint site regional settings

Update:
So, I navigeted in browser to a sharepoint site > Site actions > Site Settings > Regional settings (under Site Administration section) > in Locale listbox changed from English (United States) to English (United Kingdom) and the format of date shown in browser (used by Sharepoint) became the "correct" one (changed from previous 'MM/DD/YYYY' to 'DD/MM/YYYY', which is what I have set)

Update:
It worked for me in Sharepoint online 2010 (Office 365) while the found on internet solutions of setting date format in code did not work
Note that I wrote about machine operating system and sharepoint site's regional settings, not formatting used in Infopath (date picker control) itself

Update2:
Just to second my guess that the same Infopath form uses different settings.
If it is run in browser, i.e. through/by IPFS Sharepoint Server 2010's Infopath Form Services), then it uses sharepoint settings and when as Filler/client application then local/client machine Windows settings.
For example, in the same form username() in browser shows my sharepoint username (i:0#.f|membership|gennadyvanin@gennadyvanin.onmicrosoft.com) and run as Filler/client form the username from client machine Windows (Administrator).

eEdit the form in browser or Microsoft Infopath

share|improve this answer
    
Hi, I tried your solution but it does not work. Any clues to know which is the offending one - the time setting in the OS, or the SharePoint Settings or the InfoPath Settings? –  Jack Aug 21 '12 at 8:52
    
Hmmm, worked for me. Though, there are at least 4 places with regional settings possibly involved which are in: 1)server's operating system; 2)sharepoint site; 3)Infopath ("Format..." button in Dat Picker control); 4)client machine's operating systems, they are many –  Gennady Vanin Novosibirsk Aug 21 '12 at 9:28
    
Yeah, I can only set the settings in all your places except the 1)Server's operating system, wonder if that could be the reason for not working. –  Jack Aug 21 '12 at 9:33
    
By the way, could it also be some settings that we need to set inside the Internet Explorer in order to reflect the date? –  Jack Aug 21 '12 at 9:37
1  
Thanks for the Update2. Actually, I already notice that if I publish the form as non-web form (meaning using the client to open the form, the date will be correctly rendered.) However, if I choose the web form option, the date will be reflected wrongly. I was thinking if it is possible to copy the "date configuration" of the client application settings of the form to the web application settings (Infopath Form services). –  Jack Aug 30 '12 at 5:44
show 3 more comments

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.