ASP.NET Grid - Custom Date Filters for Localized Dates

ORDER ID
NAME
ORDER DATE
SHIPPED DATE
REQUIRED DATE
 
 
 
 
 
 
10273
QUICK-Stop
05/09/94
9/5/1994 12:00:00 AM
12/09/94
9/12/1994 12:00:00 AM
03/10/94
10/3/1994 12:00:00 AM
10274
Vins et alcools Chevalier
06/09/94
9/6/1994 12:00:00 AM
16/09/94
9/16/1994 12:00:00 AM
04/10/94
10/4/1994 12:00:00 AM
10275
Magazzini Alimentari Riuniti
07/09/94
9/7/1994 12:00:00 AM
09/09/94
9/9/1994 12:00:00 AM
05/10/94
10/5/1994 12:00:00 AM
10277
Morgenstern Gesundkost
09/09/94
9/9/1994 12:00:00 AM
13/09/94
9/13/1994 12:00:00 AM
07/10/94
10/7/1994 12:00:00 AM
10278
Berglunds snabbköp
12/09/94
9/12/1994 12:00:00 AM
16/09/94
9/16/1994 12:00:00 AM
10/10/94
10/10/1994 12:00:00 AM
10279
Lehmanns Marktstand
13/09/94
9/13/1994 12:00:00 AM
16/09/94
9/16/1994 12:00:00 AM
11/10/94
10/11/1994 12:00:00 AM
10282
Romero y tomillo
15/09/94
9/15/1994 12:00:00 AM
21/09/94
9/21/1994 12:00:00 AM
13/10/94
10/13/1994 12:00:00 AM
10283
LILA-Supermercado
16/09/94
9/16/1994 12:00:00 AM
23/09/94
9/23/1994 12:00:00 AM
14/10/94
10/14/1994 12:00:00 AM
10284
Lehmanns Marktstand
19/09/94
9/19/1994 12:00:00 AM
27/09/94
9/27/1994 12:00:00 AM
17/10/94
10/17/1994 12:00:00 AM
10285
QUICK-Stop
20/09/94
9/20/1994 12:00:00 AM
26/09/94
9/26/1994 12:00:00 AM
18/10/94
10/18/1994 12:00:00 AM
 
 
 
 
 
 
1
|
2
Records: 1 - 10 of 13 - Pages: 
-
OrderDate*_o_osep_*Between_OrderDate*_o_osep_*01/01/94*_o_osep_*01/10/94*_o_asep_*ShippedDate*_o_osep_*ByYearAndMonth_ShippedDate*_o_osep_*1994*_o_osep_*9*_o_asep_*RequiredDate*_o_osep_*ByMonth_RequiredDate*_o_osep_*10

The Grid supports filtering for dates localized to various cultures.
The OnFiltering server-side event needs to be used to parse the localized dates and convert them to the standard MM/dd/yyyy format.

In this example the date columns are formatted to the dd/MM/yyyy format (used in the UK and other european countries) using the DataFormatString property.


« Back to examples