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?
Solved! Go to Solution.
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.
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?