Results 1 to 4 of 4
  1. #1
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Returns Wrong Date? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    I have the following code in a from module that works, however on 07/01/2004 it returns 06/25/2004

    The record source of the form is a query that contains [Water Approval Date]

    [Water Approval Date] is not on the form.

    What do I change to get the correct date 07/01/2004

    Thanks, John

    <pre>Private Sub Water_Approval_Check_AfterUpdate()

    If Water_Approval_Check = -1 Then ' yes
    [Water Approval Check] = True
    [Water Approval Initial] = NetUser
    [Water Approval Date] = Date
    Else ' 0 = no
    [Water Approval Check] = False
    [Water Approval Initial] = Null
    [Water Approval Date] = Null
    End If
    End Sub
    </pre>


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Returns Wrong Date? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    Have you checked the computer's clock? Perhaps the battery is running out. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

  3. #3
    Silver Lounger
    Join Date
    Jun 2001
    Location
    Niagara Falls, New York, USA
    Posts
    1,878
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date Returns Wrong Date? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    None of the above!

    After further review of this system I inherited, come to find out the previous programmer had bad naming conventions as you can see in previous post and actually had a date field called Date on the form I

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Date Returns Wrong Date? (a2k (9.0.6926) SP-3 Jet 4.0 SP-8)

    <img src=/S/doh.gif border=0 alt=doh width=15 height=15>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •