Date Time Range

[Smiely]

I need to select data FROM Date and Time TO Date and Time. Date Range is working but how to add Time to that ? I am doing it in aspx page. Can anybody send me any example ?

[Princy]

Hello,


Are you referring the code library "Date Range selector" ?
If so, you can extent the funtionality by adding TimePickers in ItemTemplate, for selecting From and To times. And set the combo text based on that TimePicker values.

Let me know if you need further assistance in this.

Thanks,
Princy.

[Smiely]

Thanks for replying Princy. Good example.

Right now I am following http://demos.telerik.com/aspnet-ajax/grid/examples/programming/filtertemplate/defaultcs.aspx example(OrderDate Range). Instead of RadDatePicker, I want to use RadDateTimePicker. So wondering how to use time with date in the functions...

<telerik:GridBoundColumn UniqueName="OrderDate" DataField="OrderDate" HeaderText="Order date" DataFormatString="{0:D}" HeaderStyle-Width="350px">

<FilterTemplate>From
<telerik:RadDatePicker ID="FromOrderDatePicker" runat="server" Width="85px" ClientEvents-OnDateSelected="FromDateSelected" MinDate="07-04-1996" MaxDate="05-06-1998" FocusedDate="07-04-1996" DbSelectedDate='<%# startDate %>' />
to
<telerik:RadDatePicker ID="ToOrderDatePicker" runat="server" Width="85px" ClientEvents-OnDateSelected="ToDateSelected" MinDate="07-04-1996" MaxDate="05-06-1998" FocusedDate="05-06-1998" DbSelectedDate='<%# endDate %>' />
<telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
<script type="text/javascript">
function FromDateSelected(sender,args) {
    var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
    var ToPicker =$find('<%# ((GridItem)Container).FindControl("ToOrderDatePicker").ClientID %>');

    var fromDate = FormatSelectedDate(sender);
    var toDate = FormatSelectedDate(ToPicker);

    tableView.filter("OrderDate", fromDate + " " + toDate, "Between");
}

function ToDateSelected(sender,args) {
     var tableView=$find("<%# ((GridItem)Container).OwnerTableView.ClientID %>");
     var FromPicker =$find('<%# ((GridItem)Container).FindControl("FromOrderDatePicker").ClientID %>');

     var fromDate = FormatSelectedDate(FromPicker);
     var toDate = FormatSelectedDat(sender);                                                                                   tableView.filter("OrderDate", fromDate + " " + toDate, "Between");
}

function FormatSelectedDate(picker){
     var date = picker.get_selectedDate();
     var dateInput = picker.get_dateInput();
     var formattedDate = dateInput.get_dateFormatInfo().FormatDate(date, dateInput.get_displayDateFormat());

     return formattedDate;
}
</script>
</telerik:RadScriptBlock>
</FilterTemplate>
</telerik:GridBoundColumn>

[Smiely]

Princy .... Telerik ..... anybody...... ???

[Smiely]

And my code behind is....

protected DateTime? startDate
        {
            set
            {
                ViewState["strD"] = value;
            }
            get
            {
                if (ViewState["strD"] != null)
                    return (DateTime)ViewState["strD"];
                else
                    return new DateTime(2010, 12, 13);
            }
        }
        protected DateTime? endDate
        {
            set
            {
                ViewState["endD"] = value;
            }
            get
            {
                if (ViewState["endD"] != null)
                    return (DateTime)ViewState["endD"];
                else
                    return new DateTime(2010, 12, 15);
            }
        }

Please help.............

[Iana Tsolova]

Hi Smiely,

Can you elaborate a bit more on the issue you are facing with the RadDateTimePicker controls?
In the preceding client-side methods the fromDate and toDate variables should be filled with the full date.

All the best,
Iana
the Telerik team

[Smiely]

Thanks for replying lana. Exactly ......client-side methods the fromDate and toDate variables should be filled with the full date.

var formattedDate = dateInput.get_dateFormatInfo().FormatDate(date, dateInput.get_displayDateFormat());

This is only date not dateTime. How do I get it there?

I want to display a data from 12/13/2010 4.00 PM to 12/14/2010 10.00 AM.

Please help

Thanks

[Iana Tsolova]

Hi Smiely,

You are right. However getting the selected date of the RadDateTimePicker would return the full date with the time. But to filter the grid with between filter function in this case you will need to handle the filtering manually instead of using the built-in command. Because when the filter function is between you would have additional intervals in the filter expression which cannot be handled by the grid. It expects:

string interval string
 
Please excuse us for the inconvenience.

Best wishes,
Iana
the Telerik team