Hi

Does anybody have any specific examples of using DNN 6/knockoutjs/entityframework/sql server and dates? Nothing seems to be coming up trumps at all :(

Specifically I enter a date of birth in an ASP.NET webform like 22/05/1970 (or even better use a calender control or something), and this posts the date via javascript (via knockoutJS):

Right now I initialise like this:

DOB: ko.observable(new Date())

or maybe even like this:

DOB: ko.observable()

This is how my postData is handled:

 DOB: viewModel.DOB()

 

And this is my form which I type in:

<div class="dnnFormItem">
<dnn:label id="plDOB" runat="server" controlName="txtDOB"></dnn:label> <asp:TextBox id="txtDOB" runat="server" data-bind="date: DOB"></asp:TextBox>
</div>

Ultimately this goes into a SQL Server datetime field!

So far postings on other forums have been far too much for my tiny brain to handle, so I'm posting here as an act of despiration! I seem to have no problem with other value types.

Has anybody actually done this within DNN? Could you share a full example?

Cheers

Alex

---

---

---

Hi Joe

That's a point, why the heck am I using a server side control for this! Anyway I'm wanting to do this client side of course and bundle all the data into one post for the big push. OK I'll have a look at datepicker right now.

Yes I've tried debugging. The issue is definately to do with the wrong type or wrong values (i.e. NULL being returned). I've been given a gizillion code examples and nothing seems to be working out.

Values are being delivered like this:

 var _request = {
                requestUri: _serviceURL + "/myTable",
                method: "POST",
                data: _postData
            };

Other type values such as strings and integers work just fine.

"Both JavaScript and Microsoft format dates differently which can lead to problems."

Exactly right, generally brain hemorrhage!

I'm wondering if anybody has any specific examples on how they've managed to post dates to SQL Server via knockout.

---

---

---

Alex,

  I'll whip up a Jsfiddle here in a bit with a working date example which should help you get started.

---

Joe Brinkman
DNN Corp.