ultimategc3
Programmer
Hello All...
I've a problem filtering the datetime column, i've tried many trials:
li_cur = ddlb_filtercol.finditem(ddlb_filtercol.text,0)
ls_col_type = dw_1.Describe(ls_column_name+".ColType")
If ls_col_type = "datetime" then
ls_column_name = Trim(dw_1.Describe("#"+string(li_cur)+".Name"))
ls_match_data = String(ddlb_data.text)
// the problem exists here:
ls_filter = ls_column_name + ddlb_op.text + "~"" + ls_match_data + "~""
dw_1.setfilter(ls_filter)
dw_1.filter()
// Extra information
// column name = "ilc_dat"
// ls_filter = ilc_dat="10/16/2010 11:25:23"
// DATAWINDOW TYPE MISMATCH
Thank You
I've a problem filtering the datetime column, i've tried many trials:
li_cur = ddlb_filtercol.finditem(ddlb_filtercol.text,0)
ls_col_type = dw_1.Describe(ls_column_name+".ColType")
If ls_col_type = "datetime" then
ls_column_name = Trim(dw_1.Describe("#"+string(li_cur)+".Name"))
ls_match_data = String(ddlb_data.text)
// the problem exists here:
ls_filter = ls_column_name + ddlb_op.text + "~"" + ls_match_data + "~""
dw_1.setfilter(ls_filter)
dw_1.filter()
// Extra information
// column name = "ilc_dat"
// ls_filter = ilc_dat="10/16/2010 11:25:23"
// DATAWINDOW TYPE MISMATCH
Thank You