crystal report for shifting schedule

i updated my code like this:

If ComboBox1.Text = "Shift 1" Then
Dim rpt As New EndofShift() 'The report you created.
Dim MyCommand As New SqlCommand()
Dim myDS2 As New loghistory() 'The DataSet you created.
Dim myDA2 As New SqlDataAdapter()
Dim myDS As New DSactualguesting() 'The DataSet you created.
Dim myDA As New SqlDataAdapter()
Dim cn As New SqlConnection(ConnectString())
Dim dt As DateTime = "06:00:00AM"
Dim dt2 As DateTime = "02:00:00PM"
Try

MyCommand.Connection = cn
MyCommand.CommandText = "Select * from actualguesting"
MyCommand.CommandType = CommandType.Text
myDA.SelectCommand = MyCommand
myDA.Fill(myDS, "actualguesting")

myDA.SelectCommand.CommandText = "Select username,loggedin,loggedout from loghistory where username='" + Login.txtuser.Text + "' order by loggedin "
myDA.Fill(myDS, "loghistory")

myDS.EnforceConstraints = False
rpt.SetDataSource(myDS)
CrystalReportViewer1.ReportSource = rpt
Catch Excep As Exception
MessageBox.Show(Excep.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error)
End Try

End If


my formula in summing up the total sales between 6AM to 2pm is like this:
if {loghistory.username}='ches' and
{loghistory.loggedin}>= datetimevalue(CurrentDate,Time (05,59 ,59 )) to
datetimevalue(CurrentDate,Time (13,59 ,59 ))
and
{actualguesting.paymentmode}='CASH'
then
sum({actualguesting.totalamount})


when i run the report,it sum up all the records but not in the time i logged in