Select to view content in your preferred language

Dates showing null

126
1
2 weeks ago
Labels (1)
Snackman
New Contributor

Hello,

I am importing a .csv file to display point data, and am trying to classify the points using unique values based off of the date fields. However, the attribute table shows the date's coming in as <null> values. 

I am wondering if this is an issue with how the dates are formatted in Excel. If so, what is the best format to use to get those to show up correctly in ArcPro?

I would like to keep the string showing as mmddyyyy ideally, but would be fine with showing just the year drilled as well.

Would this be a formatting thing in Excel, or would I need to use the Arcade function in Arc to correct this?

I am trying to attach screenshots, but having trouble locating the function on the help page here...

Thanks in advance!

 

 

0 Kudos
1 Reply
MErikReedAugusta
MVP Regular Contributor

To start with the easy, obvious question: What is the data type of the field that's supposed to be holding the date?  Is it actually DATE, or is it a TEXT field, or something else?

The next question would be how the dates are formatted in the underlying Excel document.  Excel can be tricky, since it converts everything to display as text on the fly, and inconsistencies can sneak through.  Try selecting that column, and changing the Numbering type to "General", and make sure all of your dates change to 5-digit serial numbers.  If some don't, those cells have formatting issues that could be causing you problems.

 

Regarding posting pictures to the forums, there should be a button on the toolbar just above the text box that looks like a little camera:

MErikReedAugusta_8-1745272969436.png

------------------------------
M Reed
"The pessimist may be right oftener than the optimist, but the optimist has more fun, and neither can stop the march of events anyhow." — Robert A. Heinlein, in Time Enough for Love
0 Kudos