Thank you Mike. My problem is the Last Inspection Date field is only 4 characters long so I can't store the date in it. I was hoping I could combine an expression into this method but I guess that won't work. I think I will have to create a new field.
This method will pull the value to the source feature, you could then set up expression to pull out only the date.
I am trying to accomplish something similar but I want to populate the Last Inspection Date in my asset feature class with the year (YYYY format). Is there a way to set up this method to return just the year part from a date field?
Thanks!
Looks like a bug trying to copy a date value. Any chance you could send me a sample set of data so I can create a repo case?
Edit Log Started at: 10/12/2017 8:41:17 AM-----------------------------------------Attribute Assistant start editingProcess Count: 0Unwiring the events#######################################################Inspection - ON_CHANGEStarting AA***********************************************************############ 10/12/2017 8:41:37 AM ################
Setting sort order: Field - RUNORDER Querying table for Last Value for layer: Inspection Query Used: (TABLENAME = '*' OR TABLENAME = 'Inspection' OR TABLENAME like 'Inspection|*' OR TABLENAME like 'Inspection|%') AND VALUEMETHOD = 'Last_Value' Number of results: 0 Querying table for rules for layer: Inspection Query Used: (TABLENAME = '*' OR TABLENAME = 'Inspection' OR TABLENAME like 'Inspection|*' OR TABLENAME like 'Inspection|%') AND ON_CHANGE = 1 Number of results: 1 Looping through the rows ------------------------------------------------ Row Info Row Number 1 TableName: Inspection FieldName: DATE ValueInfo: BMP|LAST_INSPECTED|BMP_ID|BMP_ID ValueMethod: UPDATE_LINKED_RECORD On Create: 1 On Change: 1
Checking for Subtype Restriction Field Name: DATE was found at index: 2 Trying: UPDATE_LINKED_RECORD Getting Value Info Checking values Checking Field in Edited Layer Checking for related record Trying to Copy Value to the Record ERROR: Could not Copy: 10/13/2017 12:00:00 AM to field: LAST_INSPECTED Related record not found. Finished: UPDATE_LINKED_RECORD ------------------------------------------------DONE---------------------------------------#######################################################Wiring the eventsAttribute Assistant start editingAttribute Assistant is being suspendedAttribute Assistant is being turn offAttribute Assistant is being turn off**************************************Closing Log File 10/12/2017 8:41:54 AM
Edit: DATE and LAST_INSPECTED are both date fields. I'm using a file geodatabase.
Can you enable the Attribute Assistant log file, it will help us troubleshoot the issue.
I'm attempting to do something very similar and have been unable to get this method to work.
I'm having the same issue. Did you ever resolve your issue?
Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.