nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Arcgis Pro - Field Calculator - Change time to 12:00:00AM

RickeyFight

So I have some old data that has time in the date field. I do not want time in the date field.

I know that I can set the time to 12:00:00AM to make the time disappear from the field.

I need a way to update all the records (different days) to have the same time of day but keep the original date.

Any suggestions on how to do this?

Find more posts tagged with

Content Management

Accepted answers

All comments

jcarlson

You just need to pull out parts of the date first, then build the new timestamp using the Date function.

var oldDate = $feature["sale_date"]

var y = Text(oldDate, 'Y')
var m = Text(oldDate, 'MM')
var d = Text(oldDate, 'DD')

var newDate = Date(y, m, d, 0)

return newDate

RickeyFight

@jcarlson

Thanks for the quick reply. What language is this in Arcade?

When I run the script as arcade it adds one day and sets the time to 7:00:00AM

jcarlson

Yes, sorry, it's Arcade. You might be dealing with a time zone offset, it sounds like.

RickeyFight

@jcarlson

I got the time to display right by changing to 17 for time. But it keeps adding a month to the calculated value.

this is what my field looks like

and this is what I get after running the script you suggested

var oldDate = $feature.reinspect_date

var y = Text(oldDate, 'Y')
var m = Text(oldDate, 'MM')
var d = Text(oldDate, 'DD')

var newDate = Date(y, m, d, 17)
return newDate

DanPatterson

I will let you get rid of the fluff.. Example using universal format for "now"

from datetime import datetime

n = datetime.now()

new_n = n.replace(hour=12, minute=00)

new_n

datetime.datetime(2021, 4, 7, 12, 0, 11, 262084)

Datetime has a "replace" option

Almost forgot... you can use it to see how things will be in the future... like next year 😉

future = n.replace(minute=00, hour=12, second=00, year=2022, month=4, day=7)
future
datetime.datetime(2022, 4, 7, 12, 0, 0, 262084)

RickeyFight

@DanPatterson

Unfortunately I cannot get your suggestions to work.

JoshuaBixby

Can you elaborate on what isn't working? Are you getting error messages, unexpected results?

RickeyFight

@JoshuaBixby

I don't know where to start with Dan's suggestion

jcarlson

Instead of "n" being datetime.now(), replace it with the attribute value of the feature.

DanPatterson

I was using a date example... aka "now".

The datetime module help topic on python.org gives a precise definition of the methods and properties. "replace" is one of those. You can replace anything in a datetime object. My examples were to show what was possible.

If you are in need of an immediate solution, go with whatever you understand. I am more interested in teaching people how to fish rather than handing out fish at the shore 😉

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.