topic Re: Attribute Assist Add In Time Date stamp with format YYYYMMDDHHNNSS in State & Local Government Questions

Attribute Assist Add In Time Date stamp with format YYYYMMDDHHNNSS

JenniferPollom — Wed, 14 Aug 2013 16:26:04 GMT

Does anyone know how to get a time date stamp in the YYYYMMDDHHNNSS format (NN for minutes) using Attribute Assist Add In?

I can not get neither an Expression nor the TIMESTAMP method to return a time/date stamp in YYYYMMDDHHNNSS format (NN for minutes).

I have tried both string and date field types. I have tested the TIMESTAMP value Info field parameters. I have tried the following.

DateTime.Now.Day.ToString() & DateTime.Now.Month.ToString() & DateTime.Now.Year.ToString() & DateTime.Now.Hour.ToString() & DateTime.Now.Minute.ToString()

Re: Attribute Assist Add In Time Date stamp with format YYYYMMDDHHNNSS

MikeMillerGIS — Wed, 14 Aug 2013 18:19:39 GMT

We use the tostring() to format the date time string
DateTime.Now.ToString(VALUEMETHOD value)

Here is some help:

http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx

http://stackoverflow.com/questions/8128383/datetime-now-tostringyyyy-mm-dd-hhmmss-is-returning-am-time-instead-of-pm

Re: Attribute Assist Add In Time Date stamp with format YYYYMMDDHHNNSS

JenniferPollom — Wed, 14 Aug 2013 22:55:57 GMT

When you say,

DateTime.Now.ToString(VALUEMETHOD value)

Are saying that I should put the following in the VALUEINFO attribute of the DynamicValue table? EXPRESSION is the Attribute Assistant method that I currently have in there, but I have also tried TIMESTAMP and neither works.

DateTime.Now.ToString(EXPRESSION)

From the links that you sent, which I had used previously, I would think that the following would work with to give me a 14 character time date stamp, but it does not

VALUEMETHOD attribute value in DynamicValue table = EXPRESSION

and the

VALUEINFO attribute value in DynamicValue table = DateTime.Now.ToString("yyyyMMddHHmmss")

Re: Attribute Assist Add In Time Date stamp with format YYYYMMDDHHNNSS

MikeMillerGIS — Thu, 15 Aug 2013 11:24:41 GMT

No, that is what the code uses. You just need to specify your format string. Have you turned on the log file? Does it report an error?

Re: Attribute Assist Add In Time Date stamp with format YYYYMMDDHHNNSS

JenniferPollom — Thu, 15 Aug 2013 15:18:39 GMT

I am actually wondering if some of my problems (new one with LAST_VALUE method) have to do with the fact that I am using Attribute Assist on a table and not a feature class. From the help, it says the following:

http://resources.arcgis.com/en/help/localgovernment/10.1/index.html#/Attribute_Assistant_add_in_overview/028s0000008n000000/

The Attribute Assistant uses a series of predefined methods to automatically populate attributes when updating or adding new features to the geodatabase.

Re: Attribute Assist Add In Time Date stamp with format YYYYMMDDHHNNSS

MikeMillerGIS — Thu, 15 Aug 2013 15:34:23 GMT

Some rules work on a tables(some cant, like intersect feature), the best way to see what is going on is turn on the log file and look for error messages.

Re: Attribute Assist Add In Time Date stamp with format YYYYMMDDHHNNSS

JenniferPollom — Thu, 15 Aug 2013 15:55:54 GMT

I do have the log file on and it says the following:

Row Info
        Row Number 2
        TableName: Planned_Projects
        FieldName: yyyyddmmhhmmss
        ValueInfo: DateTime.Now.ToString("yyyyMMddHHmmss")
        ValueMethod: EXPRESSION
        On Create: 1
        On Change: 0

      Checking for Subtype Restriction
      Field Name: yyyyddmmhhmmss was found at index: 43
                  Trying: EXPRESSION
                  Checking to verify there is a field to store the expression
                  ERROR: evaluating the expression for feature in Planned Projects with OID of 60
                         Object required: 'DateTime'
                  Finished: EXPRESSION

Re: Attribute Assist Add In Time Date stamp with format YYYYMMDDHHNNSS

MikeMillerGIS — Thu, 15 Aug 2013 16:55:27 GMT

Use the timestamp method and just use your format string. You should not use the expression method.

Re: Attribute Assist Add In Time Date stamp with format YYYYMMDDHHNNSS

JenniferPollom — Thu, 15 Aug 2013 18:24:25 GMT

That worked. Thank you.