Avatar of IScoop

asked on 

Date Time AM versus PM

I need to sort my records into those created in the AM and those created in the PM I have a field that holds the date, how some ever, It only has the date in it when I look at the records in MS SQL. I am building a VB 2008 front end for a MS SQL 2005 express back end. So, I need to store the full date time for each record and then be able to pull a report on just the AM records or just the PM records. This is what is stored in the date column in SQL: 2009-02-28 00:00:00.000
Private Sub txtDate_GotFocus(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtDate.GotFocus
        'Puts Today's Date in Text Box
        txtDate.Text = Format(Now, "General Date")
    End Sub

Open in new window

Visual Basic ClassicMicrosoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment
Anthony Perkins

8/22/2022 - Mon