topic FIELD_TRIGGER value method to set a date? in State & Local Government Questions

FIELD_TRIGGER value method to set a date?

AlisonGaiser — Mon, 12 Nov 2012 17:23:05 GMT

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

Re: FIELD_TRIGGER value method to set a date?

LindsayThomas — Thu, 15 Nov 2012 22:14:08 GMT

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

Re: FIELD_TRIGGER value method to set a date?

AlisonGaiser — Fri, 16 Nov 2012 12:57:19 GMT

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

Re: FIELD_TRIGGER value method to set a date?

LindsayThomas — Fri, 16 Nov 2012 15:54:32 GMT

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