Start Building Professional
Web Apps Today


 
Categories Question details Back To List
Question  posted by Gigi on Apr 29, 2009 01:51
open dhtmlx forum
dhtml calendar

Hi,

I am using agrid with colTypes edn,edn,calendar
and i have used clumn sorting int,int,date

But if i m giving a date in the format (dd-Mon-yyy) that column is displayed blank.

here is my sample xml
<?xml version="1.0" encoding="UTF-8"?>
<rows>
    <row id="1">
        <cell>-1500</cell>
        <cell>12.99</cell>
        <cell>05/01/1998</cell>
    </row>
<row id="2">
        <cell>-1501</cell>
        <cell>12.99</cell>
        <cell>12-Mar-1998</cell>
    </row>

</rows>
Answer posted by Alex (support) on Apr 29, 2009 07:45

Hello, 

The calendar excell requires date in the correct javascript format.

mm/dd/yyyy

So, there must be <cell>05/01/1998</cell> in the xml.

Using setDateFormat method you can display the date in the necessary format:

grid.setDateFormat("m-d-y");