Allow non-USA formats in DATE_FORMAT | Voters

Allow non-USA formats in DATE_FORMAT

planned

YES Integrations

Many SmartSuite users are not from the US, but the DATE_FORMAT() formula only allows dates to be formatted in the MM/DD/YY format, instead of in DD/MM/YY.

January 31, 2024

Jon Darbyshire

marked this post as

planned

Stoyan Daskaloff • Design Lead @ SmartSuite

Hello YES Integrations. Thank you for the request !

We are currently working on the Formula Formatting capabilities that will let you use different Locale and Time Format for the output. This will also be applied to the Date Field itself.

YES Integrations

Hi Stoyan Daskaloff • Design Lead @ SmartSuite, I think I was actually wrong here and the locale used by DATE_FORMAT() is controlled at the workspace level

Ricardo Rodriguez

I actually prefer YYYYMMDD (without separators), so a lot of flexibility for the date format would be really helpful.