Set-up and creating data files > Software Preferences > Error message: System.Data.OleDb.OleDbException: Syntax Error in date in query expression

Looking for something specific in the page and not quite sure where to find it? You can always press CTRL + F on your keyboard and type a keyword. Or you can do a search (in the top right corner).

« AgExpert Analyst Knowledge Base

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 August 19, 2014 by FCC AgExpert