Mike,
Question was about FoxyClasses Grids classes. Some of grid classes (Locator, MultiSelect) take an SQL parameter and builds a grid with sorting, searching, highlighting etc etc capabilities (VFP5 and up supported).
Dates and datetimes are shown with whatever format user has but all are searchable in dtoc(,1) format. I like it that way. If user wants to have the format as dd/mm/yyyy instead, source code is at their hand. I find it unlogical for date/time to start search by DD or MM :)
Cetin
>Hey Cetin
>
>Here's a suggestion! Switch to an index tag built with this format dd/mm/yyyy to do the SEEK, and then switch back to the dtoc(,1) for display.
>
>>>Thanks, that seems to be okay now.
>>>
>>>The date field in the grid is now DD/MM/YYYY but the search does not seem to work when I type 12/11/2002?
>>>
>>>Am I doing somthing wrong?
>>
>>Robin,
>>Date and datetime fields use dtoc(,1) and ttoc(,1) formats. Your search entry would be in YYYYMMDD and YYYYMMDDhhmmss (24hrs) format.
>>Cetin