Problem with setDateFormat in Grid using Calendar

Suite and Optimus Suite 5
#1

I am unable to get Calendar working properly in a Grid. I am using an xml file that has a format of “%Y%m%d” which I suspect is not parsing properly. See below code example.

gridKeyword = new dhtmlXGridObject(“ps_keyworddetail”);
gridKeyword.setImagePath("…/…/AJ/common/imgs/");
gridKeyword.setSkin(“modern”);
// gridKeyword.setDateFormat("%d/%m/%Y","%Y%m%d")
gridKeyword.setHeader("#master_checkbox,Campaign ID, Name, Status,Start Date,End Date,Impressions,Clicks, CTR, Budget");
gridKeyword.setInitWidths(“40,70,265,65,,,,,,”)
gridKeyword.setColTypes(“ch,ro,ro,ro,dhxCalendar,dhxCalendar,ro,ro,ro,price”);
gridKeyword.setColAlign(“center,left,left,left,left,left,left,left,left,left”);
gridKeyword.setColSorting(“connector,connector,connector,connector,date,date,connector,connector,connector,connector”);
gridKeyword.enableSmartRendering(true);
gridKeyword.enableMultiselect(true);
gridKeyword.init();
gridKeyword.attachEvent(“onDhxCalendarCreated”,function(calendar){
calendar.setDateFormat("%d/%m/%Y","%Y%m%d");
});

The calendar appears with a date of 12/31/1969 every time. I am using Grid Pro evaluation version, any ideas?

#2

By %Y%m%d - do you mean that there is no any separation between digits ?
Default parsing logic will not work if you are using just a raw numbers without delimiters.