Date format can be display like 2021-04-04

[liminjun]

For Chinese people, we familiar with the format of date. for example: 2021-04-04, so Can I modify the display format of date in [Builder].

Thank you.

[Joel-1ada]

Hi @liminjun, these 2 following posts can help you:

UTC & Time Zone Conversion

What is UTC? Coordinated Universal Time (UTC) is the primary standard for regulating clocks and time around the world. In Honeycode, all dates and times are in UTC, which may require a simple conversion to set up notifications in your local time zone. Formula To convert UTC to a different time zone, we can use the NOW() function to subtract/add the offset to UTC and divide by 24. =NOW()-offset to UTC/24 Returns the date and time in offset time zone. Pacific Standard Time (PST) is eight h…

UK currency and date format

Feature requested: Please add in date format style for UK and currency for UK pounds sterling. What’s the problem that you’re looking to solve? I would like to use Honeycode to develop a database to track catering orders for our company. We're in the UK, and not being able to record dates in UK format completely stops us in our tracks. There's too much risk that team members will type in dates in UK format, that will then save in the wrong order, and confuse / lead to mistakes. We also need to…

Especially the 2nd post has proposed a workaround using the concatenate() function. I let Honeycode team provide more info.

Hope it can help you