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; } } }

Entering date in a table and transforming the date to text puts the date to a day before

KristinVernon1

I need some help with dates in ArcGIS Pro. I have an enterprise geodatabase table that a user would enter dates through different products. I am entering the dates directly through ArcGIS Pro.

I created a "DateOnly" column that would basically extract ONLY the date part of the Datetime field so that I may use it for reporting purposes. However as you can see in the screenshot, when transforming the date, it sets the date a day earlier. It seems that when I set the time to earlier than 6 is when I have this issue.

Please, how can I fix this?

Find more posts tagged with

Analysis

Geodatabase

Desktop

Accepted answers

KristinVernon1

So what I ended up having to do after much trial and error was change the dates to UTC then format it using the Date formula so it becomes how I want it to.

All comments

kenbuja

Unless you tell it otherwise, it assumes that the date and times are in UTC instead of your local time zone. If you set the time zone in your layer in ArcGIS Pro, does it still exhibit this problem?

KristinVernon1

I tried using the "ToLocal()" arcade expression but no dice. This is a geodatabase table that I'm entering the data into

KristinVernon1

I have below a screenshot of my contents pane. I enabled the Time field and put the correct time zone in the layer named "Water Device", however it is in the Standalone Tables that I am having the time issue. Nevertheless I set the time zone in the Water Device layer and the problem still persists in the Standalone Tables.

KristinVernon1

I noticed that when I copy the date time without the time into the new field it sets the time to 6, I wonder if this has anything to do with the fact that my timezone is -6, please any help on this?

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.