topic Re: Help me calculate field records with small python code in ArcGIS Pro Questions

Help me calculate field records with small python code

shotatskhovrebashvili — Thu, 14 Sep 2023 13:03:31 GMT

I have a python code that works for a single record:

from datetime import datetime, timedelta
utc = datetime(1980, 1, 6) + timedelta(seconds=1325841623 - (35 - 17))
print(utc)

Result: 2022-01-10 09:20:05

How can I modify the code so it can calculate each record in the field by that formula?

EarlMedina — Thu, 14 Sep 2023 13:09:13 GMT

What's the input/value that changes across the records? Is it the date (1980, 1, 6)?

shotatskhovrebashvili — Thu, 14 Sep 2023 13:12:15 GMT

The input values are GPS seconds, like: 1325841623 and after using the formula you get the date in UTC: 2022-01-10 09:20:05

shotatskhovrebashvili — Thu, 14 Sep 2023 13:19:08 GMT

I have thousands of records to be converted. Here are few examples:

1325841623; 1325841625; 1325841626; 1325841627; 1325841628; 1325841629; 1325841630;

EarlMedina — Thu, 14 Sep 2023 16:17:11 GMT

Okay, so all you have to do is pop open your Field Calculator, write a simple function, and apply to your target date field like so:

With your sample values, I get:

shotatskhovrebashvili — Thu, 14 Sep 2023 18:17:43 GMT

Thank you so much 😍