OBOUT - ASP.NET Grid - Filtering Localized Dates

Quick Links

ASP.NET Grid - Filtering Localized Dates

ORDER ID

NAME

ORDER DATE

SHIPPED DATE

REQUIRED DATE


11067	Drachenblut Delikatessen	04/05/98 5/4/1998 12:00:00 AM	06/05/98 5/6/1998 12:00:00 AM	18/05/98 5/18/1998 12:00:00 AM
11066	White Clover Markets	01/05/98 5/1/1998 12:00:00 AM	04/05/98 5/4/1998 12:00:00 AM	29/05/98 5/29/1998 12:00:00 AM
11064	Save-a-lot Markets	01/05/98 5/1/1998 12:00:00 AM	04/05/98 5/4/1998 12:00:00 AM	29/05/98 5/29/1998 12:00:00 AM
11063	Hungry Owl All-Night Grocers	30/04/98 4/30/1998 12:00:00 AM	06/05/98 5/6/1998 12:00:00 AM	28/05/98 5/28/1998 12:00:00 AM
11060	Franchi S.p.A.	30/04/98 4/30/1998 12:00:00 AM	04/05/98 5/4/1998 12:00:00 AM	28/05/98 5/28/1998 12:00:00 AM
11057	North/South	29/04/98 4/29/1998 12:00:00 AM	01/05/98 5/1/1998 12:00:00 AM	27/05/98 5/27/1998 12:00:00 AM
11056	Eastern Connection	28/04/98 4/28/1998 12:00:00 AM	01/05/98 5/1/1998 12:00:00 AM	12/05/98 5/12/1998 12:00:00 AM
11055	HILARION-Abastos	28/04/98 4/28/1998 12:00:00 AM	05/05/98 5/5/1998 12:00:00 AM	26/05/98 5/26/1998 12:00:00 AM
11052	Hanari Carnes	27/04/98 4/27/1998 12:00:00 AM	01/05/98 5/1/1998 12:00:00 AM	25/05/98 5/25/1998 12:00:00 AM
11050	Folk och fä HB	27/04/98 4/27/1998 12:00:00 AM	05/05/98 5/5/1998 12:00:00 AM	25/05/98 5/25/1998 12:00:00 AM

1 - 10 of 15 - Pages:

Apply Filter | Hide Filter | Remove Filter

StartDate_OrderDate,EndDate_OrderDate

value,value

Year_OrderDate

value

Month_OrderDate

value

YearMonth_Year_OrderDate,YearMonth_Month_OrderDate

value,value

StartDate_ShippedDate,EndDate_ShippedDate

value,value

Year_ShippedDate

value

Month_ShippedDate

value

YearMonth_Year_ShippedDate,YearMonth_Month_ShippedDate

value,value

StartDate_RequiredDate,EndDate_RequiredDate

value,value

Year_RequiredDate

value

Month_RequiredDate

value

YearMonth_Year_RequiredDate,YearMonth_Month_RequiredDate

value,value

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.

ASP.NET

<obout:Column runat="server"  DataFormatString="{0:dd/MM/yy}" DataField="OrderDate">
    <FilterOptions>
        <obout:CustomFilterOption IsDefault="true" ID="Between_OrderDate" Text="Between">
            <TemplateSettings FilterTemplateId="OrderDateBetweenFilter" 
                FilterControlsIds="StartDate_OrderDate,EndDate_OrderDate"
                FilterControlsPropertyNames="value,value" />
        </obout:CustomFilterOption>
        <obout:CustomFilterOption ID="ByYear_OrderDate" Text="Filter By Year">
            <TemplateSettings FilterTemplateId="OrderDateByYearFilter" 
                FilterControlsIds="Year_OrderDate"
                FilterControlsPropertyNames="value" />
        </obout:CustomFilterOption>
        <obout:CustomFilterOption ID="ByMonth_OrderDate" Text="Filter By Month">
            <TemplateSettings FilterTemplateId="OrderDateByMonthFilter" 
                FilterControlsIds="Month_OrderDate"
                FilterControlsPropertyNames="value" />
        </obout:CustomFilterOption>
        <obout:CustomFilterOption ID="ByYearAndMonth_OrderDate" Text="Filter By Year And Month">
            <TemplateSettings FilterTemplateId="OrderDateByYearAndMonthFilter" 
                FilterControlsIds="YearMonth_Year_OrderDate,YearMonth_Month_OrderDate"
                FilterControlsPropertyNames="value,value" />
        </obout:CustomFilterOption>
    </FilterOptions>
</obout:Column>