Dates for Created and Modified are visible in grid, but dates for Due Date and Start Date are invisible in grid.
If I set column type to ed for Due Date and Start Date I can see dates.
The only difference I can see is that Created and Modified come from TIMESTAMPs in a MySQL db while Start Date and Due Date come from TIMEs in a MySQL database.
function dejaTasks()
{
grid3.setColumnIds(getColumns());
grid3.setHeader(“Subject,Priority, Due Date, Category, Status, Contact, Location, Project, Note, Start Date, Done, Created, Modified”);
grid3.setInitWidths(“250,55,100,200,180,90,100,100,400,100,45,150,150”)
grid3.setColAlign(“left,left,left,left,left,left,left,left,left,left,left,left,left”)
grid3.setColTypes(“ed,ro,dhxCalendar,ed,ed,ed,ed,ed,ro,dhxCalendar,ch,dhxCalendar,dhxCalendar”);//changed 3 and 10 from dhxCalendar
grid3.setColSorting(“str,str,str,str,str,str,str,str,str,str,na,str,str”);
grid3.enableEditEvents(false,false,false);
grid3.enableEditTabOnly(true);
grid3.enableMultiselect(true);
grid3.customGroupFormat = function(text, count)
{
if(text == " ")
text = “(Blank)”
if(currentGroup == “category”) group = “Category”
else if(currentGroup == “priority”) group = “Priority”
else if(currentGroup == “edate”) group = “Due”
else if(currentGroup == “status”) group = “Status”
else if(currentGroup == “contact”) group = “Contact”
else if(currentGroup == “location”) group = “Location”
return group + ": " + text + " - " + count + " records"
};
if( grid3.getColumnId(11) == "Created" || grid3.getColumnId(12) == "Modified")
grid3.setDateFormat(getDateFormat() + " " + getTimeFormat(),"%Y-%m-%d %H:%i:%s");
else grid3.setDateFormat(getDateFormat());
grid3.attachEvent("onEditCell",function(stage,id,ind)
{
if (ind == 2 || ind == 9 || ind == 11 || ind == 12)
return false;
return true;
})