You'd need to add code (perl code) to the routine to set the new field to the datetime value of NOW() when/if the right condition is met.
If you define the field as datetime it will store a full datetime value, and only update when you ask it to. I use several of these fields in the postcards database to track when cards are sent, picked up, last picked up, etc., and I set them in the subroutine that assigns them.
I'm not sure where in your set up you'd need to set them.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ
If you define the field as datetime it will store a full datetime value, and only update when you ask it to. I use several of these fields in the postcards database to track when cards are sent, picked up, last picked up, etc., and I set them in the subroutine that assigns them.
I'm not sure where in your set up you'd need to set them.
PUGDOGŪ
PUGDOGŪ Enterprises, Inc.
FAQ: http://pugdog.com/FAQ