General

Re: RE: DateTime Picker to format- dd/mm/yyyy- 14-Sep-2021 in infopath form(SP list)

Hilary Stoupa — Mon, 20 Sep 2021 14:33:21 GMT

There isn't a way to override this behavior, that I know of. I suppose you could provide a button in the form that sets the date picker to today for last year or something....

Re: RE: DateTime Picker to format- dd/mm/yyyy- 14-Sep-2021 in infopath form(SP list)

Keerthi06 — Mon, 20 Sep 2021 08:16:35 GMT

Hi Hilary, Thanks for that. I am now cleared with your point which you conveyed for my first question. For Second question, what i asked is how will the user be able to see previous years by navigation of data time control. Red color highlighted area -> i used to click the button navigate back and front to select previous and upcoming months, how do i select the year 2020,2019,.etc.... in one go (without going and selecting the previous months button one by one) Please refer attached screenshot to understand my question clearly.

Re: RE: DateTime Picker to format- dd/mm/yyyy- 14-Sep-2021 in infopath form(SP list)

Hilary Stoupa — Fri, 17 Sep 2021 18:50:58 GMT

SharePoint is storing dates as DateTimes. It displays them formatted based on the user's regional settings. We can't override the way they are displayed - so if you have specific display needs, you'll need to use a calculated column. I don't understand your other question - that is just how date pickers work? You can always type in the date and year in the yyyy-DD-mm format: 2020-08-09

Re: RE: DateTime Picker to format- dd/mm/yyyy- 14-Sep-2021 in infopath form(SP list)

Keerthi06 — Thu, 16 Sep 2021 16:17:04 GMT

Hi Hilari, Thanks for your response. I have two queries still: 1)So even if we give 14-Mar-01 in InfoPath, The only way to show the desired output - 14-Sep-21 -> we have to add a calculated column in this list (as per your reference link). 2) Also, could you please guide me on how to select the previous years in the DateTime picker field, as I am currently selecting the button to move forward and backward of a month for the same year. Thanks for your help in advance.

Re: RE: DateTime Picker to format- dd/mm/yyyy- 14-Sep-2021 in infopath form(SP list)

Hilary Stoupa — Thu, 16 Sep 2021 15:18:22 GMT

In your customized list form, you can change the format on the date picker - right click the control, select format and pick the desired format. For the list data, you probably have to add a calculated column and display that in the list: https://answers.microsoft.com/en-us/msoffice/forum/all/date-format-in-sharepoint-list/0ff61fbe-d968-4523-a537-d9161a53036b

RE: DateTime Picker to format- dd/mm/yyyy- 14-Sep-2021 in infopath form(SP list)

Keerthi06 — Thu, 16 Sep 2021 13:08:21 GMT

Hi All, I am using the InfoPath Form 2013 as a backend in a SharePoint list. I have created a date time picker with Date Type -> "Date Only". I need to show the date field with this format - 14-sep-2021 in the date field ( SP list). I tried changing the formats but InfoPath shows only the mm/dd/yyyy -> 9/14/2021 format. In my list, i could see the same format (9/14/2021). Details: Date1.pmg - date properties screenshot of my IP form. Date_output.png - date output -> date field passed into the textbox and shown in the preview mode of Infopath Please help out to get my desired output -> 14-Sep-2021.