🚀 go-pugleaf

Hello,

I'm having trouble with selecting date/time from an Access database. Access
is storing date/time as "m/d/yyyy h:n:s ", that is without the leading zero
e.g. (7/9/2002 1:6:6) .

When reading from a ini-file I'm getting the date/time as 2002-09-07
01:06:06, what I'm doing is:



TDateTime dateTime = mIni->ReadString("basics", "date", DEFAULT );



  String sql = "SELECT * FROM tblDate WHERE fldDate = #" +
dateTime.FormatString("m'/'d'/'yyyy h:n:s") + "#";



  ADOQuery1->Close();

  ADOQuery1->Prepared = false;

  ADOQuery1->SQL->Text = sql;

  ADOQuery1->Prepared = true;

  ADOQuery1->Open();



When debugging this, the date is matching Access underlying format, but it
will not work.

The debugger is reporting:

"EoleException with message, parameter-object is defined wrong. The given
information is inconsequent or incomplete".



I then created a view in Access and come up with the following:



SELECT tblDate.fldDate

FROM tblDate

WHERE (((tblDate.fldDate)=#9/9/2002 1:6:6#));



When passing that I'm getting the same error, what is wrong here?
Thanks in advance,
John