Ann,
I am doing something similar. I wonder if you can help...
I have an UPDATE field for an inventory DB which autmatically poulates with NOW() whenever something in the record changes.
My UPDATE field is defined as TEXT. Problem is 1) when I view it, I see the day & time. ie., 7/25/2005 1:49:00 p.m. 2) when I search on date, obviously it doesn't find any records b/c the field isn't storing the day, but the day & time.
Question....how do I format NOW()? So I can use it?