But I am trying to change all of the Date column rows to a particular date value.
I noticed there are a few methods of setting values, but would like to find a simple solution to set every row in my column, even perhaps without using a loop.
Sorry, you need a loop,overwriting ‘editData’ every time…from java.util import Date
day = Date.parse("some date")
resultsPy1 = system.db.runQuery(query1)
editData = system.dataset.toDataSet(resultsPy1)
idx = editData.getColumnIndex("Date")
for r in range(editData.rowCount):
editData = system.dataset.setValue(editData, r, idx, day)Using the column index instead of the column name will speed it up some for large datasets.