<div>
or are you looking for a date format which is ## delimited
</div>


or are you looking for a date format which is ## delimited

<div>
Ok, I guess the problem is that I was attempting to incorporate a DateTime value into my query, since I had had favorable success doing so with SQL Server. &nbsp;What's the next best thing in Access?
</div>


Ok, I guess the problem is that I was attempting to incorporate a DateTime value into my query, since I had had favorable success doing so with SQL Server.  What's the next best thing in Access?

<div>
If you are generating your queries in code with parameterised SQL then you could just add a datetime type parameter to your query, and set its value to a datetime from your code.<br />
<br />
How are you generating your queries?<br />
<br />
Andy
</div>


If you are generating your queries in code with parameterised SQL then you could just add a datetime type parameter to your query, and set its value to a datetime from your code.

How are you generating your queries?

Andy

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
While interacting with SQL Server, the following date format works:<br />
<br />
SELECT * FROM Alerts WHERE CreationDateTime &gt;&nbsp;{ts '2006-04-12 10:00:00'} ORDER BY ID ASC<br />
<br />
But it generates an exception when using Access with an OleDbConnection.<br />
<br />
What is the corrrect time stamp format for Access?<br />
<br />
<br />
Thanks,<br />
Bob
</div>
</div>


Hi,

While interacting with SQL Server, the following date format works:

SELECT * FROM Alerts WHERE CreationDateTime > {ts '2006-04-12 10:00:00'} ORDER BY ID ASC

But it generates an exception when using Access with an OleDbConnection.

What is the corrrect time stamp format for Access?


Thanks,
Bob

Malformed GUID in query expression

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).