Thanks for the suggested workaround. That could be a way to format the data indeed. But I hope there would be plans for something more robust and systematic.
Plus there is a side-effect to this method : that second column is also sent through every API request which does not specify the requested properties - that is quite redundant and not efficient.
Hi, @Howard_Jacobson .
I would like to clarify, what you are talking about.
As I understood you want the dates in web-console were displayed in a some other formats (by choose), right? I mean in developer web-console , not in ui-builder or any other pages which will be shown to the users of your app.
Hi. My request is that Backendless console data browser AND UI Builder provide a date formatting function like the DATE function in PHP. I understand that Backendless is not written in PHP.
Definitely works, but limiting. For example, users in Europe will want day/month/year but users in the U.S. want month/day/year. Some of our users prefer yyyy-mm-dd. Having a date formatting function allows me to give users their preference. With a generated column, I’d have to have a separate generated column for each format, right? And some of my tables have 4 date columns.
If you need a date formatting function, you can apply it in the UI. Data in the database is stored in one neutral format. How you present it to the users is entirely the function of the frontend.
UI Builder is based on JS and supports any browser API, you can find the “Date” category in the Codeless as well as you can use CustomJSCode to display a Date in any format
Totally agree with @Howard_Jacobson on this one. Generated columns could work but are very cumbersome (and redundant) to set up, especially when there are many date columns. Plus it does not allow editing in the console.
The issue here is not with displaying dates to users. It is to display dates in the admin console. And US dates are definitely a no-go for international app admins. MM-DD-YYYY is VERY confusing for dates like March 7th 2023 : it gets confused for July 3rd 2023.