Arcgis select by attribute the day of the week in date field

Question

I am trying to select a specific day in the "Select by attributes" tool. I know you can select using a day from 0-31 like this:

EXTRACT(DAY FROM "TimeStampStart") = 5

But I was wondering is there a way to select a specific day in the week (sunday to saturday)? for example select only days of week = tuesday?

P.S This is not the answer I am looking for: https://pdgisusers.org/2010/12/15/extract-day-of-the-week-from-a-date-field-in-arcgis/

and already looked into this :http://support.esri.com/technical-article/000011531

I have a csv file with a datetime field.

Answer 1

If you want to use some Python, it's pretty simple to extract the day of week. There's some limitations working with csv, but the following should be a good starting point:

table = "test.csv"

# list of days to extract, starting with Monday at 1
days = [1,2,3,4,5]

# First field is unique key field used for select, second is date field
# Would be "OID@" if a GDB table
fields = ['Field1', 'Field2']

# Find all key field values
keys = [k for k,d in arcpy.da.SearchCursor(table, fields)
            if d.isoweekday() in days]

# Make new view with selection, export, etc.
sql = "{} IN ({})".format(fields[0], ",".join(map(str, keys)))
arcpy.MakeTableView_management(table, "selection", sql)

It would be trivial to create a toolbox script that takes a csv and day(s) of week as input (maybe even the field names as well).