Solved: Treating Formatting Date Field as Value - Page 2

V-A · 02-01-2023 06:35 PM

Using the AppSheet Journal template, I created a virtual column to format the date of each row (in "YYYY-MMM-DD" format) and used that virtual column as the "Group by" column. Since the app treats this virtual column as text, the months are sorted alphabetically, e.g. Feb is displayed before Jan.

It seems the only way around this is to have that text virtual column treated as a value. Is this possible while still having that virtual column displayed formatted?

V-A

Thanks for clarifying. The two-step filter won't work for my use case, though the single column grouping worked without user pre-filtering by month or year.

This seems to be a known AppSheet limitation. The closest I can get to my desired output format is by using the "Use long date format" under the date type. This removes the need for a virtual column. Otherwise, keep the virtual column and for grouping have the date text displayed in YY-MM-DD format (rather than DD-MM-YY common in some locales outside the U.S.) and numerically ("MM" rather than "MMM" or "MMMM").

The "long date format" is likely a system setting. I don't know if and how to modify it. If you do, please let me know.

View solution in original post