WebGrid Community Server

Hi,

I have a problem with the search option. I want to search a date field but it does'n work correct.
As example:
If i type the search tekst '1956' the recordset returns all the records from the persons who has born in the year 1956.

If i type the search tekst '12-04-1956' the recordset returns nothing.

The Column part is:
<WG:DateTime 
   ColumnId="Geboren" 
   EditAlign="Right" 
   GridAlign="Left" 
   IsInDataSource="True" 
   Primarykey="False" 
   Priority="40" 
   Required="False" 
   Title="Geboren" 
   Visibility="Both" 
   Searchable="True" 
   Format="dd-MM-yyyy"
/>

I hope that somebody can help me..

Regards Marc

WebGrid searches directly from the database, and i'm not sure if you can search for a formatted date-time field.

You should try to store the datetime field in same format as you search for it.

Is it possible to find a date in a other format? Which format must i use?

Regards,

Marc