topic Entering date in a table and transforming the date to text puts the date to a day before in ArcGIS Pro Questions

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

KristinVernon1 — Wed, 31 Aug 2022 16:43:27 GMT

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?

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

KenBuja — Tue, 30 Aug 2022 23:28:38 GMT

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?

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

KristinVernon1 — Tue, 30 Aug 2022 23:48:57 GMT

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

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

KristinVernon1 — Wed, 31 Aug 2022 17:00:05 GMT

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.

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

KristinVernon1 — Wed, 31 Aug 2022 22:53:37 GMT

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?

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

KristinVernon1 — Mon, 05 Sep 2022 15:22:30 GMT

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.