Select to view content in your preferred language

Archive Connection Date Format

197
0
10-26-2022 06:18 AM
chapmang
New Contributor

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)

chapmang_0-1666789782385.png

However, selecting a date like the 26th October throws a database connection issue.

chapmang_1-1666789859410.png

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)

chapmang_3-1666789951915.png

When adding feature classes to the map they show the date.

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.

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)

0 Kudos
0 Replies