I’m doing a rollup count, then sorting a list in descending order on that rollup column. It seems to treat the column as text not numbers? Eg. 7 is above 38, 20 is above 118 and so on.
Guess I’ve never ran across that scenario. The quick fix would be to pass the rollup through a math column (might have to do something like multipling it by 1 to guarantee the result is numeric).
Kind of curious though what your Rollup is doing and what kind of columns is it looking at? Feels buggy to me.
1 Like
I checked and rechecked everything. Found the issue but can’t solve it.
Word of advice, if something seems buggy or more than just slightly off, then it’s always a date columns fault - GUARANTEED!!!
What the heck is going on with dates???
They never work like they are mean’t to.
A date column should just always be accompanied by a column next to it that in fact gives you the actual date.
Why is there even such a thing as a date column if its always formatted wrong???
DATE COLUMNS ARE FOR LOSERS!!! - You know how much time i’ve wasted on this thing.
Does anyone have something better i can use, something that just works!!!
I need to to sort a date column in descending order. Shouldn’t that be a simple thing?
Since the official “date column” doesn’t ever work, what is the column that i will always put next to it that offers the “correct date”
Is there a way to format the date column?
FEATURE REQUEST COMING UP
- We need a date column that is ALWAYS formatted correctly!!
lol, If my attitude seemed a little buggy, or more than just slightly off here in this post, then you have obviously read me wrong, i suggest you get a secondary column to display my correctly formatted attitude! Which is in fact always happy, though you’ll possibly never know… (unless you got a secondary column for me?)
SOLUTIONS
Column 1: Date that you want to format (use a date column)
Column 2: In row 1 add this date January 1, 1900 at 12:00 PM (use date column)
Column 3: Single Value on column 2 (single value column)
Column 4: Column 1 minus Column 3 (use math column for this)
Column 5: Column 3 Plus Column 4 (use math column for this)
I was able to use column 4 for my specific problem but the column 5 give a nice way to display the date. (plus many other uses i’m sure)
What’s your original setup for your buggy date column? What’s your data source?
Glide tables, basic date column, If then else column to pull through the date column if a condition is met, then use the if then else column to sort a table collection on the app in descending order.
So the issue was with the format with the if-then-else column right? It returns a Zulu format?
(not sure what a zulu format is) but it seems to sort the numbers as text, because 20 will be above 118 etc (i’m sorting descending order)
So i think it’s reading the first character only (not sure)
I believe it returns as Zulu format because one of your options for if-then-else is not date (or blank). Maybe you can convert it to a numeric format before sorting?
1 Like
I think that’s what this solution achieved. The math column is giving a value of 45419.1918518519 which the ITE column seems to be happy with.
Thanks for your help.
5 columns seems a bit much… could we see a screenshot of how the ite column is configured?
Or you could take your date and convert it to a number like ThinhDinh suggested and then sort on that number
YEAR(DATE)*10^8+MONTH(DATE)*10^6+DAY(DATE)*10^4+HOUR(DATE)*10^2+MINUTE(DATE)
1 Like
Thats just to get the date column, the ITE column is extra.
Basically the date column is always needed and currently i’m pulling from “Column 4” so to speak. (column 5 is just for people to use for other formulas)
So it’s really just 3 extra columns to do what the date column should be doing right from the start.
At the minimum you don’t need the date in row 1 and then a single value… you could replace that with one template column.
I’d still recommend the formula to convert it to a number because there other cases where it will become handy
I tried this and it didn’t work? That does work for some other apps i’ve used, i’m not sure if using the ite column to filter that result and sort descending is perhaps not the real issue.
The ITE column is literally just pulling that date column through. Has anybody been able to sort an ITE column that pulls through a BASIC DATE Column??
Late to the party here, but are you saying that sorting a Collection or Query by Profile->Join Date doesn’t work as expected?
It should.
I think the issue is he’s trying to sort from an ite column and some of the options in the ite column are not dates… maybe a blank 
2 Likes
Good idea, thanks.
I have an old habit of using single value for that purpose. I will use your idea to omit a few other columns too.
1 Like
It’s definitely just a date formatting issue. The ITE Column is not recognising the date column as a date, so i’m unable to sort a table collection on that ITE column.
I Think with Eric’s suggestion i can solve the issue with just two columns, so i would say thats a decent solution for this problem.