SQL Query - Items between a start date and time and a stop d & t 1

[i2rjames]

Example of what's required.
I want all records between the date 2006-01-01 time 10:30 to
date 2006-04-06 time 17:15.

The records have a date and a time field

How do I structure an SQL statement to get the above?

Thanks

James

 

[Nordlund]

Add the Date and the Time database field and compare them against the local tdatetime-value

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
-"There is always another way to solve it, but I prefer my way.

 

[i2rjames]

Thanks Nordlund,

That works fine, thanks for the fast response.