Date Formatting in VIEWS:
How can i change the format of DATE and TIME values that are shown in a table view? For example; the default for date seems to be "DD/MM/YYYYโ which for me takes up too much โreal estateโ in a table view. And for TIME i want to display in 24hr format โฆ not like 11:19 AM, the the same reason.
Thank you in advance.
Thanks Suvrutt !
For displaying date and time formats in proper manner ,please also go through following article
help.appsheet.com - Locale Support in AppSheet Locale Support in AppSheet help.appsheet.com
If you wish to have date format as dd/mm/yy format,you may wish
use the following expression in a virtual column of text type
=(LEFT(Text([Date]), 6))&RIGHT(Text([Date]), 2)
where [Date] is date column.
You can display date in different formats say DD MMM YY etc. by using expressions.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |