Error message: System.Data.OleDb.OleDbException: Syntax Error in date in query expression

The following message may appear when opening the Chart of Accounts:

System.Data.OleDb.OleDbException: Syntax Error in date in query expression

'(((Transactions_Details, TransactionNo)= [Transactions], [TransactionNo]) AND

((Transactions.Date) Between #2005.01.01# and #2005.12.31#) AND

((Transactions_Details].[Type]<>'0' AND

[Transactions_Details].[OpenBal]= 'Y')=False) AND ((Transact'.

@ AEF.glbDataHelper. GetDataReader(String sSql)

@ AEF. prvAccountBalanceBase.GetSortedList(DateTime dtMinDate, DateTime dtMaxDate)

@ AEF. prvAccountBalance.GetSortedListByDate(DateTime dtMinDate, DateTime dtMaxDate)

@ AEF. AEF.mgrAccounts.GetBalances(DateTime dtMinDate, DateTime dtMaxDate)

Solution:

The Short Date Format on your computer is set up incorrectly. Make sure that:

• you’re using a slash, and not a dot, to separate the dates
• the days, months and years are correct

To find out how to change your date format, read this article.

Last updated on February 6, 2014 by FCC AgExpert