Retrieve Unique Dates From Attribute Field

MikeEdwards

Hello,

I'm trying to pull all of the unique dates out of an attribute field and I'm having issues formatting the output. Right now I have the following:

table = r"C:\Temp\SomeFile.shp"
field = "ADD_DATE"
valueList = []
rows = arcpy.SearchCursor(table)

   for row in rows:
      valueList.append(row.getValue(field))

uniqueSet = set(valueList)
uniqueList = list(uniqueSet)
uniqueList.sort()

del rows
del row

print uniqueList

The output is datetime.datetime(2017, 9, 19, 14, 28, 29) I'd like it to simply be 2017/09/19

Can anyone help?

bixb0012

You will want to use the newer Data Access cursors:  SearchCursor—Help | ArcGIS Desktop.  Python's Counter class was specifically made for situations like this.

<SPAN class="keyword token">from</SPAN> collections <SPAN class="keyword token">import</SPAN> Counter

table <SPAN class="operator token">=</SPAN> r<SPAN class="string token">"C:\Temp\SomeFile.shp"</SPAN>
field <SPAN class="operator token">=</SPAN> <SPAN class="string token">"ADD_DATE"</SPAN>

cnt <SPAN class="operator token">=</SPAN> Counter<SPAN class="punctuation token">(</SPAN>dt <SPAN class="keyword token">for</SPAN> dt<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>table<SPAN class="punctuation token">,</SPAN>field<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">for</SPAN> dt<SPAN class="punctuation token">,</SPAN> freq <SPAN class="keyword token">in</SPAN> cnt<SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> dt<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">print</SPAN> dt<SPAN class="punctuation token">.</SPAN>strftime<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"%Y/%m/%d"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>