topic Re: Attribute Assistant - Timestamp question in Water Utilities Questions

Attribute Assistant - Timestamp question

TimWitt2 — Mon, 06 Feb 2017 17:51:43 GMT

Hey everybody,

I am trying to get my timestamp in a certain format: YYYY-MM-DDThh:mm:ss.s but I am not able to do it.

As an example it needs to look like this: 2017-02-20T23:16:45.7

Is this even possible? If so, what would be the expression I need?

Thanks,

Tim

Re: Attribute Assistant - Timestamp question

JoeBorgione — Mon, 06 Feb 2017 21:09:31 GMT

Tim- after spending a little time with google I notice that t or T is often used to designate PM, but in a 24 hour clock, do you need to specify that? (2017-02-20T23:16:45.7) Tenths of a second seems pretty extreme; I haven't found a format for that yet.....

timw1984‌

Re: Attribute Assistant - Timestamp question

TimWitt2 — Mon, 06 Feb 2017 21:22:26 GMT

I know it is crazy, I am just looking through the upcoming NENA standards

This is what I am talking about:

1403 5.37 Date Updated 1404 Description: The UTC date and time that the record was created or last modified. This 1405 value SHOULD be populated upon modifications to attributes, geometry, or both. 1406 Domain: Restricted to ISO 8601 compliant values in Coordinated Universal Time (UTC). 1407 Values are not allowed to be in the future. 1408 Example: 2010-12-19T20:01:29-05 (representing a record updated on December 19, 2010 1409 at 8:01 and 29 seconds PM US Eastern Standard Time)

Re: Attribute Assistant - Timestamp question

JoeBorgione — Mon, 06 Feb 2017 21:32:11 GMT

I often wonder about the practicality of NENA standards; I don't know what percentage I'm NENA compliant, but somehow we get the right truck or car to the right address in the shortest amount of time...

Looking at that document, I don't see tenths of a second. Currently I provide a date of when a record was last modified. ( I expect the NENA black Suburban to pull up any minute now and take me away.) Instead of AA, you could try using the Editor Tracker and specify UTC...

Re: Attribute Assistant - Timestamp question

TimWitt2 — Tue, 07 Feb 2017 13:04:09 GMT

I pulled the decimal from their Date Field description:

D – Date and Time fields are as defined by the International Organization for Standardization (ISO) 8601 standard and are a NENA requirement. Date and time use ISO 8601 compliant formats which are in the format of YYYY-MM-DDThh:mm:ss.sTZD and conform to a TimeStamp as defined in NENA-STA-010 [1] , which in turn conforms to W3C dateTime format. Example: 2014-02-20T23:16:45.7-05:00 744 2014 = the Year 02 = the Month 20 = the Day NENA Standard for NG9-1-1 GIS Data Model NENA-STA-006.1-201X, Month Day, Year [MM/DD/YYYY] Page 29 of 86 23 = the Hour 16 = the Minute 45.7 = the Seconds and decimal fraction of seconds –05:00= the Offset from UTC Note: The Offset from Coordinated Universal Time (UTC) is the optional separator to indicate the time zone designation, which in this example is -5:00 to indicate the local Eastern Standard Time (EST) time difference from UTC.

I'll have to check out editor tracker!

Re: Attribute Assistant - Timestamp question

MikeMillerGIS — Tue, 07 Feb 2017 13:43:35 GMT

We are using DateTime.Now.ToString<http://DateTime.Now.ToString>(format string) to set the date time. You just need to find the correct format string to specify in the value info. Make sure the field is a string you are storing the value in.

Re: Attribute Assistant - Timestamp question

TimWitt2 — Tue, 07 Feb 2017 14:57:53 GMT

Hey mmiller-esristaff‌

thanks for the reply! So I would have to create the Field, in which I want the timestamp to go as a string field. Then I would use the Expression method for that field to fill in the timestamp?

Could you post a basic example of the DateTime.Now.ToString I would have to use? From there I can probably figure it out myself.

Thanks!

Tim

Re: Attribute Assistant - Timestamp question

JoeBorgione — Tue, 07 Feb 2017 17:37:05 GMT

Tim- see of this helps: .net - DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss") is returning AM time instead of PM time? - Stack Overflow

Re: Attribute Assistant - Timestamp question

TimWitt2 — Tue, 07 Feb 2017 17:54:29 GMT

Joe, I tried that earlier but it didn't work. Maybe I was using it wrong? I even tried that in the field calculator and it didn't work. Thanks for posting though!

Re: Attribute Assistant - Timestamp question

MikeMillerGIS — Tue, 07 Feb 2017 18:16:48 GMT

It will not work in the field calculator. Can you post what the aa debug/log file is reporting?

Re: Attribute Assistant - Timestamp question

TimWitt2 — Tue, 07 Feb 2017 18:42:35 GMT

Row Info
Row Number 20
TableName: *
FieldName: DateUpdate
ValueInfo: DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
ValueMethod: EXPRESSION
On Create: 1
On Change: 1

Checking for Subtype Restriction
Field Name: DateUpdate was found at index: 68
Trying: EXPRESSION
Checking to verify there is a field to store the expression
Expression to be eval: DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
ERROR: evaluating the expression for feature in Brevard_Nena_Street with OID of 42394
Object required: 'DateTime'
Finished: EXPRESSION

Re: Attribute Assistant - Timestamp question

MikeMillerGIS — Tue, 07 Feb 2017 19:10:36 GMT

Using your value info through the debugger, I get a proper date and the process completes

>? args[0]

"yyyy-MM-dd HH:mm:ss"

>? DateTime.Now.ToString(args[0])

"2017-02-07 14:08:04"

What version are you using? I would suggest trying out the preview of the next release

https://github.com/Esri/local-government-desktop-addins/tree/dev/PreviewBuilds

Also, you need a string field as the date/time field will display the date based on your system date time formatting.

Re: Attribute Assistant - Timestamp question

MikeMillerGIS — Tue, 07 Feb 2017 19:12:24 GMT

Hold on, why are you using this in expression? Just use the TIMESTAMP value method and yyyy-MM-dd HH:mm:ss as the value info

Re: Attribute Assistant - Timestamp question

TimWitt2 — Tue, 07 Feb 2017 19:43:45 GMT

Michael thanks for the help. What I will end up doing is create a DATE field and a TIME field and then write an expression for my DateUpdate field looking like this: [DATE] & "T" & [TIME] & "-05:00"