Hey,
Im trying for a message box to pop up with a price, depending on the time. Before 11:30 costs £3.00, afterwards costs £4.50. This is what i have tried but it this code gives me the message for £3.00 when the time is over 11:30
Dim day As String = Format(Today, "dddd")
Dim time As Date
time = DateTime.Now.ToString("hh:mm:ss")
Select Case day
Case "Sunday"
If time > "11:30:00" And time < "23:59:59" Then
MsgBox("£4.50 Please")
Else
MsgBox("Coffee Morning:" & vbCr & "£3.00 Please")
End If
Case "Monday"
Case "Tuesday"
Case "Wednesday"
Case "Thursday"
Case "Friday"
Case "Saturday"
End Select
Any help?
Thank you !