Date Formatting in VIEWS: How can i change t...

ux
(Krittaporn Kumada) #1

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.

(Krittaporn Kumada) #2

Thanks Suvrutt !

(Suvrutt Gurjar) #3

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

(Suvrutt Gurjar) #4

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.