https://community.esri.com/t5/arcgis-pro-questions/archive-connection-date-format/m-p/1225613#M61564 <P>We have an SDE instance set up is SQL server and a handful of feature classes with archiving enabled on them. When creating a connection to the database with a specific data and time we are having issues with date formats. Being UK based when set the connection properties the GUI provides a calendar that is formatted as we would expect (Day/Month/Year)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="chapmang_0-1666789782385.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/54450i40D81CF1806EDCA6/image-size/medium?v=v2&amp;px=400" role="button" title="chapmang_0-1666789782385.png" alt="chapmang_0-1666789782385.png" /></span></P><P>However, selecting a date like the 26th October throws a database connection issue.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="chapmang_1-1666789859410.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/54451iF258529DDAD0EDE7/image-size/medium?v=v2&amp;px=400" role="button" title="chapmang_1-1666789859410.png" alt="chapmang_1-1666789859410.png" /></span></P><P>Selecting a data like the 6th October does connect however when you reopen the dialog box the date has reverted the US style format (Month/Day/Year)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="chapmang_3-1666789951915.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/54453iFBEA0289B826A7DF/image-size/medium?v=v2&amp;px=400" role="button" title="chapmang_3-1666789951915.png" alt="chapmang_3-1666789951915.png" /></span></P><P>When adding feature classes to the map they show the date.</P><P>When using the History panel via the data connection in the TOC everything works just fine, and the GUI shows and responds to GB date formats.</P><P>As our end objective is to publish certain epochs as a service on ArcGIS Server we want to get the SDE file configured correctly so that we can register it with the server (unless of course I'm missing something else entirely)</P> Wed, 26 Oct 2022 13:18:20 GMT chapmang 2022-10-26T13:18:20Z https://community.esri.com/t5/arcgis-pro-questions/archive-connection-date-format/m-p/1225613#M61564 <P>We have an SDE instance set up is SQL server and a handful of feature classes with archiving enabled on them. When creating a connection to the database with a specific data and time we are having issues with date formats. Being UK based when set the connection properties the GUI provides a calendar that is formatted as we would expect (Day/Month/Year)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="chapmang_0-1666789782385.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/54450i40D81CF1806EDCA6/image-size/medium?v=v2&amp;px=400" role="button" title="chapmang_0-1666789782385.png" alt="chapmang_0-1666789782385.png" /></span></P><P>However, selecting a date like the 26th October throws a database connection issue.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="chapmang_1-1666789859410.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/54451iF258529DDAD0EDE7/image-size/medium?v=v2&amp;px=400" role="button" title="chapmang_1-1666789859410.png" alt="chapmang_1-1666789859410.png" /></span></P><P>Selecting a data like the 6th October does connect however when you reopen the dialog box the date has reverted the US style format (Month/Day/Year)</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="chapmang_3-1666789951915.png" style="width: 400px;"><img src="https://community.esri.com/t5/image/serverpage/image-id/54453iFBEA0289B826A7DF/image-size/medium?v=v2&amp;px=400" role="button" title="chapmang_3-1666789951915.png" alt="chapmang_3-1666789951915.png" /></span></P><P>When adding feature classes to the map they show the date.</P><P>When using the History panel via the data connection in the TOC everything works just fine, and the GUI shows and responds to GB date formats.</P><P>As our end objective is to publish certain epochs as a service on ArcGIS Server we want to get the SDE file configured correctly so that we can register it with the server (unless of course I'm missing something else entirely)</P> Wed, 26 Oct 2022 13:18:20 GMT https://community.esri.com/t5/arcgis-pro-questions/archive-connection-date-format/m-p/1225613#M61564 chapmang 2022-10-26T13:18:20Z