Date Field Issues

Anonymous User

Good Morning,

Having difficulty with a SQL database Date Field. I have a view created to extract data used for a Web Map. All the data comes over on the view except the date field? My in house people have helped me to convert the Date Field in the view to a string and it now shows in my view copy in ArcGIS Catalog, but when using this field in Web AppBuilder, of course it doesn't show as an actual Date field, limiting my functionality. Is there a way of converting this String "Date" field to an actual "Date" field in ArcGIS so the Web Map views it as such? I have tried the Modelbuilder tool Convert Date Time, and I am looking at the Calculate Field Tool now, but not very good with VB? Any help would be greatly appreciated.

Thanks

SC

Asrujit_SenGupta

Make sure you are using a supported Date - data type.

SQL Server data types supported in ArcGIS—Help | ArcGIS Desktop 

ArcGIS data types	SQL Server data types created	Other SQL Server data types that can be viewed	Notes
BLOB	VARBINARY(MAX)	BINARY, IMAGE, TIMESTAMP, VARBINARY(n)
DATE	DATETIME2(7)	DATETIME2(n), DATETIME, SMALLDATETIME