Forum Home
Press F1
Thread ID: 608	1998-12-07 12:07:00	Date Format incorrect in Access	Guest (0)	Press F1

Post ID	Timestamp	Content	User
938	1998-12-07 12:07:00	I have a problem whereby, dates show incorrectly if the day is less than 13.. My system date is set correctly but Access shows the date 12/06/1998 in Medium format as 6th Dec 1998.. I am Updating a field using VBA and an SQL, which is as follows Private Sub Form_AfterUpdate() Dim strSQLQuery As String strSQLQuery = 'UPDATE tblMembers SET [DateLastModified] = #' & Now() & '#_ WHERE MemberID = ' & Me![MemberID] & ';' ' Execute the query. Application.SetOption 'Confirm Action_ Queries', False DoCmd.RunSQL strSQLQuery Application.SetOption 'Confirm Action_ Queries', True End Sub This is run using the afterupdate event on the form. I would like to know if anyone could help me get the date format correctly showing the date. Thanks Rick	Guest (0)
1