Bind DateTimePicker to DataTimeOffset attribute

4 posts, 0 answers
  1. Hemal Shah
    Hemal Shah avatar
    2 posts
    Member since:
    May 2010

    Posted 04 Dec 2014 Link to this post

    We have all our date fields in our Oracle DB defined as "Timestamp with Timezone". We use EF and LINQ to hydrate our VM from the DB. The VM gets populated correctly however when I try to bind a DateTimeOffset attribute to DateTimePicker component it fails.

    Can you tell me what could I be doing incorrectly. If this is not supported does someone else have any suggestions that I can try.

    Here is what I have so far 

    [DisplayName("Inactivate Date")]
    public DateTimeOffset? inactivateDate { get; set; }

    [DisplayName("Inactivate Date")]public DateTimeOffset? inactivateDate { get; set; }  
    public DateTimeOffset? activateDate { get; set; }

    [DisplayName("Energizing Date")]
    public DateTimeOffset? energizingDate { get; set; }

    View Template
    <div class="form-group">
        @Html.LabelFor(model => model.energizingDate, new { @class = "control-label col-xs-2" })
        <div class="col-xs-2">
            @Html.EditorFor(model => model.energizingDate)
            @Html.ValidationMessageFor(model => model.energizingDate)
        <div class="col-xs-3">
            <div class="form-group">
                @Html.LabelFor(model => model.activateDate, new { @class = "control-label col-xs-4" })
                <div class="col-xs-7">
                    @Html.EditorFor(model => model.activateDate)
                    @Html.ValidationMessageFor(model => model.activateDate)
        <div class="col-xs-3">
            <div class="form-group">
                @Html.LabelFor(model => model.inactivateDate, new { @class = "control-label col-xs-4" })
                <div class="col-xs-7">
                    @Html.EditorFor(model => model.inactivateDate)
                    @Html.ValidationMessageFor(model => model.inactivateDate)

    var x = dao.CONNECTIVITY_UNIT
                            .Join(dao.OP_AREA_ORG, cu => cu.OP_AREA_CODE, oa => oa.OP_AREA_CODE, (cu, oa) => new { CONNECTIVITY_UNIT = cu, OP_AREA_ORG = oa })
                            .Where(w => w.CONNECTIVITY_UNIT.UNIT_TYPE.Equals("SUBSTATION"))
                            .Where(w => w.CONNECTIVITY_UNIT.IS_ACTIVE_FLAG.ToUpper().Equals("Y"))
                            .Where(w => w.CONNECTIVITY_UNIT.ABBR.ToUpper().Equals("BRA"))
                            .Select(c => new SubstationVM
                                connectivityUnitID = c.CONNECTIVITY_UNIT.CONNECTIVITY_UNIT_ID,
                                energizingDate = c.CONNECTIVITY_UNIT.ENERGIZING_DATE.Value.DateTime,
                                activateDate = c.CONNECTIVITY_UNIT.ACTIVATE_DATE.Value.DateTime,
                                //inactivateDate = c.CONNECTIVITY_UNIT.INACTIVATE_DATE.Value.DateTime,
                                updateTime = c.CONNECTIVITY_UNIT.UPDATE_TMSTMP
                            .OrderBy(o => o.substationABBR)

    This fails when it has to find to the DateTimePicker component. I tried to bind it to plain old TextBox and it works fine.

    What am I missing.
  2. Petur Subev
    Petur Subev avatar
    1882 posts

    Posted 08 Dec 2014 Link to this post

    Hello Hemal,

    Sadly the DateTimeOffset type is still not supported by the Date/Time picker widgets of Kendo.

    You need to first cast the type to DateTime.

    Petur Subev

    Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

  3. Logan
    Logan avatar
    43 posts
    Member since:
    Apr 2013

    Posted 02 Jun 2017 in reply to Petur Subev Link to this post

    Is it still the case the datetimeoffset is not supported in the date/time picker?
  4. Stefan
    Stefan avatar
    1658 posts

    Posted 06 Jun 2017 Link to this post

    Hello Logan,

    Unfortunately, the DataTimeOffset is still not implemented.

    Still, I can suggest voting for it in our feedback portal as this will increase its changes to be implemented sooner:

    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top