I need to pull the records with todays date only. The problem is that I am using the "General" date and time field. The problem with this is that I cannot use the date() function in my query to pull those records which are only from today due to the time in the date field.

I desperately need help on this. Any help provided is very much appreciated.

Thanks.

What about it isn't working? I just put >=Date() in the Criteria of a query and it gave me all the entries already done today, even though they were inputted with Now().

Post your SQL here if you're still having problems after this. Another possibility is to format the field as Date only for the sake of your query, but that's not necessary I don't believe.

HTH,
David R


[This message has been edited by David R (edited 02-11-2002).]

This was much easier than I anticipated. I attribute this to brain freeze. Thank you so much for your help.

Dino