This is a migrated thread and some comments may be shown as answers.

[Solved] Date in Column Chart.

2 Answers 106 Views
Chart
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Sushim
Top achievements
Rank 1
Sushim asked on 11 Mar 2012, 11:32 AM
Why do I receive date format like "/Date(0234030430)/" when getting date from sql server database, I have attached a screenshot. Please reply fast. Thank you.

2 Answers, 1 is accepted

Sort by
0
Sushim
Top achievements
Rank 1
answered on 14 Mar 2012, 12:05 PM
Can anyone reply?????? Have been waiting for a week. Please reply.
0
T. Tsonev
Telerik team
answered on 15 Mar 2012, 09:07 AM
Hello,

The date is serialized in an ASP.NET-specific format that needs to be de-serialized. Possible approaches are discusses on SO, for example.

You then need to set a template for the category axis labels to use the de-serialized date:

.CategoryAxis(axis => axis
    .Categories(s => s.DateString)
    .Labels(labels => labels.Template("${ formatDate(value) }"))
)


...

<script>
    function formatDate(value) {
        var milli = value.replace(/\/Date\((-?\d+)\)\//, '$1');
        var d = new Date(parseInt(milli));


        return (d.getMonth() + 1) + " / " + d.getFullYear();
    }
</script>


I hope this helps. All the best,
Tsvetomir Tsonev
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the Telerik Extensions for ASP.MET MVC, subscribe to their blog feed now.
Tags
Chart
Asked by
Sushim
Top achievements
Rank 1
Answers by
Sushim
Top achievements
Rank 1
T. Tsonev
Telerik team
Share this question
or