More Date Formats

Currently, the only Date Format available to show the Day of the Week is: “Tuesday, July 5, 2011”.
I’d love to be able to also have other Date Formats that is SHORTER in text length.

Any of these, for example:

Tues, 7/5/2011
Tues, 07/05/2011
Tues, 2011-07-05

I don’t want to take up extra column width on the screen to show the same data :slight_smile:

Yes. This makes sense.

We are tracking this as an enhancement (BUG-004044).
Will update here once it is fixed.

1 Like

Short date formats are now available in product. Please try and let us know.

2 Likes

@ttorimoto, in particular the Date data type now includes the following additional format options:
image

Issue #004044 is now closed.

1 Like

This is great to see more date formats like “ddd, m/d/yyyy” “ddd, mm/dd/yyyy” and “ddd, yyyy-mm-dd”.
This is related to my request here:

I would really really really really … really^100 like to see a day “d” value format - I use that in the majority of my calendar and scheduling spreadsheets. Many of the other formats for labels can use the TEXT formula for display purposes, but it’s important to be able to display the “d” format and still reference the cell to do calculations based on the actual date.

1 Like

Thank your for your feedback!
Support for custom number, currency & date formats - d-mmm-yy , d-mmm , $#,##0_);($#,##0) etc - the works - (and also while importing existing spreadsheets) are relatively high priority in our short term roadmap. My guess is that we’ll be able to make it available in production in a matter of months ( 2021 itself - with a high degree of probability ).

3 Likes