Date search error

Classic Servoy
1

I have the following method to perform a search on to fields:

order_classification = ‘%Flexible Endoscope%’
approval_date = approval_date
final_inspection_completion_date = “^”
foundset.sort(‘CreatedRecvd_DateTime asc’);
controller.search();

This works great

I have another form that I am trying to build a search for using the following method:

controller.find()
final_inspection_completion_date = final_inspection_completion_date ;
shipping_date = ‘^’
foundset.sort(‘final_inspection_completion_date desc’);
controller.search();

This returns records that have empty ‘final_inspection_completion_date’ fields (ignoring the search criteria on this field), which is not the desired result. Is this maybe a date formatting issue?

Other then this one statement, everything works fine
(final_inspection_completion_date = final_inspection_completion_date )

Thanks for any insight, I am sure there is something simple i am missing.
Erich

2

Whould whould you expect to happen?
the statement final_inspection_completion_date = final_inspection_completion_date does nothing at all, it is like saying 1 = 1