Find on a datetime field.

Classic Servoy
1

I am having a time trying to do a find on a date portion of a datetime field. :x In servoy client I do the following in the date time field:

  1. Ctrl+F
  2. #11/09/09(this is the format of the date portion of the datetime field MM-dd-yy)
  3. enter (nothing happens and I get a empty foundset)

Servoy docs say to use the # symbol and the date to do find on a datetime field. If I use //,now, or today I get the correct data for the current day. However, if I use the above syntax for non current days or ranges nothing happens. Thanks in advance for all your help.

2

and if you try this:

#11/09/09|MM-dd-yy
3

#11/09/09|MM-dd-yy did not work. When using # symbol or a specific date I get an empty foundset. I can do finds on date fields just fine. What would cause this not to work on datetime fields. I disabled my default error handler and received the attached error.
[attachment=0]error.JPG[/attachment]

error.JPG
error.JPG574×260 10.1 KB

4

Fixed. You have to use the following format:

specific day:

#11/09/09|MM/dd/yy or #11-09-09|MM-dd-yy :D

search for dates greater than or equal to enterd date:

=11/10/09|MM/dd/yy *** notice that I do not use the # symbol

5

ah sorry, yes I did make a typo!
you need to use on both sides: - or /

sorry… :)