Hi,

I am trying to set up a date field in a products db that lists when a item was last in-stock.

I have an If statement that when positive it inserts todays date, but I want it to do nothing if it is negative so the date remains for good. I have inserted a "" if the result is negative, but it replaces the contents of the field with a blank.

Thanks in advance guys.

John.

I think this might be better done with a script.

It's doing just what you asked it to do. Instead of "", replace the field's contents with itself.