Searching for dates

Classic Servoy
1

I have a DATETIME field on a form; On the ‘main’ form it is displayed as the date and time, formatted like “MM/DD/YY HH:SS AM”. On a ‘listview’ form, I have the same field, but displayed as “MM/DD/YY” only (no time).

When I’m on the listview form, I can do a Find and put in “>1/1/08” to look for records past Jan 1 08. However when I’m on the main form and do the same thing, I get no results. It wants me to put in the time too, like “>1/1/08 00:00 am”.

Is there any way to make this function a bit more friendly, or do I just need to write a crazy method to parse various things the user types in and fudge the find accordingly?

2

You can use different formats for displaying and entering the data by using a pipe character:

<displayformat>|<enterformat>
3

Hi Joas,

I know, the formats for dates are working fine (at least a bit better ;-) )
But I wonder, if Servoy still has masks in the wishlist.

with mask I mean, that the separator still is showable, but you dont have to type it in.

Like this: --****

so if you type in: 28, the cursor automaticly jumps to the third *

4

Joas:
You can use different formats for displaying and entering the data by using a pipe character

But then this restricts users to only entering dates when they need to enter times to; It’s just searching that I don’t want to have to specify a time.

I guess I can try writing a custom Find method that changes the formatting of the object on the form, goes into find, and then puts it back when done… but that’s a messy hack.

I’d prefer better searching flexibility from within date/time fields…