Date Entry Error on Form

The error occurs when a date is saved to a table from a form in ATE. Also, the data being entered is going into a column with a date datatype. See attached screenshots for info on the box I am using.

Thanks!

5.3.1.7

Can you provide us with table creation script please?
Which type of database do you work with?

SQL Server 2014

USE [Datamart]
GO

/****** Object: Table [dbo].[noi_entry] Script Date: 5/29/2015 8:00:54 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[noi_entry](
[id] [numeric](18, 0) IDENTITY(1,1) NOT NULL,
[account] [varchar](10) NULL,
[forsaledate] [date] NULL,
[repo_cost] [numeric](10, 2) NULL,
[storage_cost] [numeric](10, 2) NULL,
[attorny_fees] [numeric](10, 2) NULL,
[legal_cost] [numeric](10, 2) NULL,
[impount_fees] [numeric](10, 2) NULL,
[other] [numeric](10, 2) NULL,
[pd_name] [varchar](30) NULL,
[pd_add1] [varchar](120) NULL,
[pd_add2] [varchar](120) NULL,
[pd_phone] [varchar](10) NULL,
[single_ltc] [numeric](10, 2) NULL,
[contract_bal] [numeric](10, 2) NULL,
[accrued_interest] [numeric](10, 2) NULL,
[less_unearned_finance] [numeric](10, 2) NULL,
[less_unearned_insurance] [numeric](10, 2) NULL,
[less_other] [numeric](10, 2) NULL,
[recovery_add1] [varchar](60) NULL,
[recovery_add2] [varchar](60) NULL,
[perdeim] [numeric](10, 2) NULL,
[ltc_date] [date] NULL,
[Nextdue] [date] NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

Please use OleDB connection instead of SQL server than it will work

Hi Mike,

Thanks for the reply. I changed the connection type but when I go to edit my item I get an error message.

Most likely there is problem with your conenction string (which we can't see)

un-check "Blank password"
check "Allow saving password"
enter the "User name" and "Password"