I need to extract data from an SQL server to Notes Database. The condition is to extract one day transactions and the timing should only be from 8AM until 10AM. The field “DateTime” used in the SQL view is of field type date time. (e.g. 05/05/2007 08:00:00 AM).
I can only extract the whole day transactions using the below SQL statement.
qry.SQL = "SELECT view1.field1 , " & _
"FROM view1 " & _
"WHERE (Month(view1.DateTime) = " & vmonth & "
" AND Year(view1.DateTime) = " & vyear & "
" AND Day(view1.DateTime) = " & vday & “)”
How to include the condition from 8AM to 10AM only?
Any help will be greatly appreciated.
Thanks a lot!
Regards,
Agnes
Any help will