In this case, a user-created a table using variables. When they sorted on the date/time column, not all dates were showing in chronological order. This was because there were 0s missing from some of the DD and MM values. We had to advise them to add some custom R code at the bottom of the table’s R code properties to force the sorting to occur in the expected order.

R code was:

{noformat}raw.data[,2]=as.Date(raw.data[,2],format="%m/%d/%Y")

raw.data{noformat}