jwcolby
jwcolby at colbyconsulting.com
Tue Mar 18 12:50:17 CDT 2008
I am pulling a TopN kind of thing and marking those records with GetDate() which places a date and time in a date field. Now I want to pull all the records with today's date. The first problem is that GetDate() pulls the date and time. The second problem is what to place in the filter. I am not finding a date() kind of thing like you have with Access. How do I pull all records with today's date in a date field (that also contains the time)? John W. Colby Colby Consulting www.ColbyConsulting.com