I have a question that has a simple answer but I cannot figure it out.
I have a datawindow with a datetime column. I need to do a search on that:
datetime ldt_date
string ls_date
ldt_date = Datetime(ls_date)
ls_tmp = "estimate_date =" + String(ldt_date)
ll_row = dw_temp.Find(ls_tmp, 1, dw_temp.Rowcount())
I get a -5 return. I made sure that ldt_date has the correct format.
Any help would be greatly appreciated.
ls_tmp = "String(estimate_date, 'yyyy/mm/dd') = ' " + String(ldt_date, 'yyyy/mm/dd') + " ' "
*** No space is required between single quote(') and double quote ("), added only for readability