Start Building Professional
Web Apps Today

Calendar excell fields don't display initial date

I have a grid with some calendar fields. I can edit a field, pick a date, and the date shows up in the cell. However, when I load the grid via XML, the date does not show up in the cell.

The grid column types are initialized like so :

activityGrid.setColTypes( "ro,ro,ro,ro,calendar,ro,calendar,calendar,ed,ed" );

a row of XML looks like -

<row id="434908" locked="true" >
    <cell>Requirements Definition</cell>
    <cell>A1000</cell>
    <cell>Requirements Analysis</cell>
    <cell>2008-06-16</cell>
    <cell>2008-06-16</cell>
    <cell>2008-07-03</cell>
    <cell>2008-07-04</cell>
    <cell>2008-07-03</cell>
    <cell>0.0</cell>
    <cell>100%</cell>
</row>

And the grid ends up looking like :

http://www.spintz.com/scrap/dhtmlxCalendarBug.jpg

Any idea what's going on?

The default date format is "%d/%m/%Y"
Because different format used in your case - grid need to be correctly configured

    activityGrid.setDateFormat("%Y-%m-%d")

this command need to be executed before data loading.