> Thank you! And I was so close, shouldn't it have just known what I
> meant? :)
>
> One question: what is I wanted to insert the word "now" into a string
> field? I though that by using single quotes it would treat it as a string.

try it - you'll be surprised that the server can recognise that you are
inserting NOW into a date field differently than you are inserting NOW into
a string field.
Alan