Searching in a DATETIME field

When I create a new record, Servoy auto-generates a current datetime value in the format MM/dd/yyyy; this is specified in the “Column Info” properties dialog. The date is stored in a DATETIME field. In developer, when I do a search on my DATETIME field, I get the no records found message. I know for sure that the date, I’m doing a search on, is correct. The date is in the format of MM/dd/yyyy.

See the Servoy help file. Go to “Index” and search for find. You will see an entry “Finding dates and times”. That should help.