Date Search

Classic Servoy
1

Finding Null datetime values A NULL value character ^, representing a NULL (not existing) value, can also be used in your search request.

I want to do the oppisite of the above statement.

When running a method that would search for a value in a date field how could I accomplish.

controller.find();
estimate_completion_date = ?
foundset.sort(‘CreatedRecvd_DateTime asc’);
controller.search();

This works great for a non-date field:

controller.find();
Order_Classification = Order_Classification
controller.search();

Thanks,
Erich

2

!^ should do the trick, then you are saying “not null”

3

Excellent, I have been looking for that for a while.

Thank you so much