5/5/2025 4:08:42 PM User- Source-.Net SqlClient Data Provider Exception-Conversion failed when converting character string to smalldatetime data type. StackTrace- at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at System.Data.SqlClient.SqlCommand.CompleteExecuteScalar(SqlDataReader ds, Boolean returnSqlValue) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Datacomp.AppServices.DataAccess.SQLServerDAL.VMGold.CommonLib.GetPageData(String selectClause, String fromClause, String whereClause, String orderByColumn, String sortOrder, Int32 currentPage, Int32 pageSize, Boolean returnRecordCount, UInt64& recordCount, Object filterBy, String primaryKeyColumn, Boolean isFromMobile) at Datacomp.AppServices.DataAccess.SQLServerDAL.VMGold.CommonLibSQLServerDAL.GetPageData(String selectClause, String fromClause, String whereClause, String orderByColumn, String sortOrder, Int32 currentPage, Int32 pageSize, Boolean returnRecordCount, UInt64& recordCount, Object filterBy, String primaryKeyColumn, Boolean isFromMobile) at Datacomp.AppServices.BusinessLogic.VMGold.CommonLibBusinessLogic.GetPageData(String selectClause, String fromClause, String whereClause, String orderByColumn, String sortOrder, Int32 currentPage, Int32 pageSize, Boolean returnRecordCount, UInt64& recordCount, Object filterBy, String primaryKeyColumn, Boolean isFromMobile) at Datacomp.AppServices.MediatorBridge.VMGold.CommonLibMediatorBridge.GetPageData(String selectClause, String fromClause, String whereClause, String orderByColumn, String sortOrder, Int32 currentPage, Int32 pageSize, Boolean returnRecordCount, UInt64& recordCount, Object filterBy, String primaryKeyColumn, Boolean isFromMobile) at Datacomp.AppServices.WebServiceBridge.VMGold.WM.InveLogin.InveLoginBridge.GetTransactionSummary(TransactionSummaryInputInfo inputInfo) in D:\DatacompDotnetWork\FMOnline\Production_1_2_3\VMGold\VMGMF\AppServices\ServiceBridge\WebServiceBridge\WMInveLginWebServiceBridge\InveLoginBridge.cs:line 9394 at Datacomp.AppServices.Service.VMGold.WM.WMService.GetTransactionSummary(TransactionSummaryInputInfo inputInfo) in D:\DatacompDotnetWork\FMOnline\Production_1_2_3\VMGold\VMGMF\AppServices\WCFService\Service\WMInveLoginService\WMServices.svc.cs:line 3600