Could anyone please help us if possible. We are struggling with one section of our SQL in Crystal Reports 2011.
We are adding in commands into Crystal Reports to populate our custom report with commands such as:
Code: Select all
SELECT TOP(5)
Name, RecordTime
FROM
CDBPoint JOIN CDBHistoric ON (CDBPoint.Id = CDBHistoric.Id)
WHERE
CDBPoint.Name LIKE 'M10%'
Code: Select all
Row | Name | RecordTime
=================================================
0 | M10 Available | 19/03/2013 13:54:42.679
1 | M10 Available | 19/03/2013 13:56:58.479
2 | M10 Available | 19/03/2013 13:57:35.031
3 | M10 Available | 19/03/2013 13:58:54.335
4 | M10 Available | 19/03/2013 14:01:22.910
So that part of it works fine. But now we want to add onto the WHERE such that we only get results between a certain time on a certain date and are not able to get the correct syntax.
Hopefully somebody is able to give some insight into our problem.
Thanks in advance