how to pass date parameters to Spotfire.Dxp.Data.DataTable.Select()
We are trying to filter Datatable using Spotfire.Dxp.Data.DataTable.Select() method. When we are filtering it based on String type field it is working fine, but it is not working for Date field, we tried different ways to call this but no luck . any suggestion on this would be appreaciated.
foundrows=dataTable.Select("Name='ROW-0004'"); This is working fine.
print foundrows.IncludedRowCount ; This is working fine & showing proper count.
Not working Code
foundrows=dataTable.Select("Date=1/1/2017"); this is not working
foundrows=dataTable.Select("Date=#1/31/2017#"); this is also not working
print foundrows.IncludedRowCount ; This is not working & showing error.