FIELD_TRIGGER value method to set a date?

[AlisonGaiser]

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

[LindsayThomas]

Hi Alison

Maybe try TIMESTAMP?

http://resources.arcgis.com/en/help/localgovernment/10.1/index.html#/Timestamp/028s000000mw000000/

Would that support your workflow?

Cheers,
Lindsay

[AlisonGaiser]

Thanks Linda but this doesn't really meet my needs. I tried passing in the word TIMESTAMP into the ValueInfo field parameters, but it didn't work. I even tried to set it to see if I could do something with Date.Now.AsString, but that didn't work either. I also posted in the Water Utilities Forum and received a great response from Mike Miller. Unfortunately, not an answer but definitely a promising future.

http://forums.arcgis.com/threads/71283-FIELD_TRIGGER-to-set-a-date

Thanks,
   Alison

[LindsayThomas]

Glad to hear Mike gave you a promising answer.
Cheers,
Lindsay