Hi @BubbleSam I’m running into an issue when trying to order a column by date. The data is stored as a Date. The same issue occurs when I load the table with Default ordering column set to a date column and when I toggle the asc/desc button at the top of a date column.
Expected behavior: order by unix time; most recent date/time on top when desc and furthest in the past on top when asc.
Observed behavior: there appears to be some kind of first digit integer-based sorting such that months are ordered (asc): 1(JAN),10(OCT),11(NOV),12(DEC),2(FEB),3(MAR),4(APR),5(MAY),6(JUNE),7(JULY),8(AUG),9(SEP); days of the months follow the same pattern (1,10,12,13,14,15,16,17,18,19,2,20,21,…,etc); times follow the same pattern when rendered in 24H format.
What’s going on here?