Receiving conflicting info and hope to resolved today as many of my app builds are based on “Future Follow-Update or Task Due Date”. I’ve also searched in our Community and found various answers but so far, nothing is working correctly. I posted some of the issues I was having and was told 1/by @d…

Just create a column along side your date column called whatever you want, maybe DateString. Then in the app sort by that column. Here is a picture of what it would look like [image]

@George_B You’re the best!!! Is the “date string” how the user should enter the new updated date on their app? Thank you :+1:

No. When you create the Add screen you would select a date picker component and point it to the actual date column. That other column is only for the sorting purposes.

Thanks for this! As a Finnish, I also needed this.

@George_B If I just reformat the date column with the year-month-date format in Google sheets… it sorts correctly but as soon as new entry goes in… drops to bottom of their app. Using your suggestions now. Thanks again! Update 10/7/19 - Look at difference in date format now from first to last en…

Here’s an idea that piggy backs on @George_B ’s helper column idea. You could use Helper TABS for display purposes. This is my workaround for an Admin app I use often. I use the DATEVALUE formula as my formatting method. Then the options are endless with sorting if you use a QUERY or FILTER formula o…

@Dave_McManus Per our conversation.

I think you are trying to use the spreadsheets column format option. You shouldn’t have to do that. Refer to our private conversation where I show you the formula for the helper column. Don’t use the sheets formatting. You should be writing the the original date column, but displaying and sortin…

… and I’m still here with the same issue and I can’t risk losing a client for a 2 minute fix. My expertise is identifying customer needs and providing solutions as a former turnaround consultant for many years. I really need a “Glideapps Pro” to just look at my screen for 2 minutes and show me wha…

Are you sure you are displaying the “datetext” column and not the date column?

Have you tried representing the date as plain number? The problem with Google sheets (and excel for that matter) is that dated are some time get mixed up. The good news is that each date can be represented as numbers (date fornat is just format but sheets actually see it as a number) So, I think …

Is there an alternative to 'Sort by Date'?

Ask for Help

Jeff_Hager October 14, 2019, 6:05pm 15

Last issue resolved here:

Topic		Replies	Views
In-App Sort by Date not working Report a Bug	6	1026	May 17, 2020
Sort by date doesn't work because of the day of the week Ask for Help	3	183	May 5, 2023
Order list on date Report a Bug	4	704	October 3, 2019
Sorting with current date highest up Ask for Help	17	901	May 25, 2023
Sorting order incorrect Ask for Help	4	248	December 2, 2020

Is there an alternative to 'Sort by Date'?

Related topics