how to pass date parameters to Spotfire.Dxp.Data.DataTable.Select()

Hi all,

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.

dataTable=Document.Data.Tables[tableName]

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.

 

Regards

Raghu

(1) Answer

Login