Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2004
    Location
    Burgas, Bulgaria
    Posts
    209
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date Format (Access 2000)

    Formatting dates

    How can i restrict the data to the year 2004? I want to show all the visits that has been made during 2004 on the basis of the
    LastUpdate field in the table.If i write WHERE visits.LastUpdated=2004
    i obtain an error.SHall i write Format?

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

    Re: Date Format (Access 2000)

    Assuming that LastUpdated is a date/time field, you can use the Year function:

    WHERE Year(Visits.LastUpdated) = 2004

Posting Permissions

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