I was wondering if it was possible to use the FIELD_TRIGGER value method and populate a date field? It appears that it is only a defined string or a number.
Here is the scenario, I have a table that keeps track of the road status. Included in this table is a date field for each status change (date road was poposed, date the commence work order was issued, etc.). I would like to use attribute assistant to automatically populate those fields when the status changes. I thought that the field_trigger value method might do it for me, but I am struggling with how to put in a date - sysdate preferably.
Thanks,
Alison