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?
Results 1 to 2 of 2
Thread: Date Format (Access 2000)
-
3 Star Lounger
- Join Date
- Feb 2004
- Location
- Burgas, Bulgaria
- Posts
- 209
- Thanks
- 0
- Thanked 0 Times in 0 Posts
2004-12-30 17:33Date Format (Access 2000)
-
Subscribe to get a FREE chapter from Windows 7 The Missing Manual
This month, every Windows Secrets subscriber can download a one-chapter excerpt of Windows 7: The Missing Manual.Windows 7: The Missing Manual provides valuable information to help you overcome these difficulties in learning a new operating system. Subscribe today to download your free excerpt.
-
Plutonium Lounger
- Join Date
- Mar 2002
- Posts
- 84,353
- Thanks
- 0
- Thanked 10 Times in 10 Posts
2004-12-30 17:48Re: Date Format (Access 2000)
Assuming that LastUpdated is a date/time field, you can use the Year function:
WHERE Year(Visits.LastUpdated) = 2004
