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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jdillia
-
Datetime value out of range error
I have tried dateadd("m",+1,now()) - also >date() and then >now() - to name three- jdillia
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Datetime value out of range error
I am trying to limit a query to a specific date range and have used multiple formulas but continue to get an error message that the string representation of a datetime value is out of range. Any suggestions?- jdillia
- Thread
- Replies: 2
- Forum: Microsoft: Access Queries and JET SQL
