Results 1 to 2 of 2

Thread: Compare Dates

  1. #1
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113

    Unanswered: Compare Dates

    Wondering if I need to add something more to make this work.

    Comparing current date to a date field. txtAssigneddate is bound to a table in a subform.

    Code:
    If Me.date > Me.txtAssignedDate Then
        MsgBox "Overdue", , "Overdue"
    Else
        Exit sub
    End If
    ======================
    Levent
    Access 3

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    If Date() > Me.txtAssignedDate Then
    Paul

Posting Permissions

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