Formatting date time in data grid

[crc]

What I’m trying to do:
I have a data grid that is populated by a data table from a server side query. Two of the fields are date time type. What is the best way to change the date time format from the default? Should I be using a different query, re-formatting it on the server side or changing something on the client side?

What I’ve tried and what’s not working:

Code Sample:

@anvil.server.callable
def get_inbound_list():
  inbound_list=app_tables.inbounds.search()
  return(inbound_list)

Clone link:

Login

share a copy of your app

[p.colbert]

This might be a good place to start:

How to format a datetime data binding

By default, the DatePicker is displayed in my localized format. However, a text label with data bound from the database is displayed in the format YYYY-MM-DD, and not accordingly to my browser. Is there a way to display this date in a localized format? (Chatbeaverbot is such a great help for me, a big thank you! I rely on it so much, but in this case, it couldn’t assist me) My form, a date picker and a label bound to a column in the database: [Capture] The data binding: [Capture…

Found via Anvil’s Search feature (the magnifying glass at the top of this page).

Yes, you can search for these things yourself, no waiting!