Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Last Date of current year

Status
Not open for further replies.
Costefran

Costefran

Technical User
Joined
Jan 2, 2008
Messages
197
Location
GB
Can anyone help

I am trying to find the correct syntax for a parameter query to find dates that are greater than the last day of the current year

Any help would be appreciated

thanks
 
Sort by date Sort by votes
Is date greater than last day of the current year the same thing as year greater than current year?

 
Upvote 0 Downvote
SELECT ...
FROM ...
WHERE Year([your date field]) > Year(Date())

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Upvote 0 Downvote
Worked a treat

many thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question Question
Select X of each variation of a field
Replies
8
Views
833
rashmibala
R
spartansFC
  • Locked
  • Question Question
Display Year between 2 dates
Replies
1
Views
884
dhookom
dhookom
monkeysee
  • Locked
  • Question Question
Max Date Qry
Replies
3
Views
1K
Andrzejek
Andrzejek
BugZap13
  • Locked
  • Question Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
849
mikrom
mikrom
datajockey123
  • Locked
  • Question Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
982
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top