can't delete timezone

[Rachel_Betzen]

Hello! In my Inventory Tracking table, I want to name each item as: #Order Date-Product-Supplier. Everything looks good in my form when I'm entering the info, with the date format as expected, but then in my "Name" function field, timezone is included as "T00:00:00.000Z" I've tried reformatting the date field, deleting and re-adding, hiding it - nothing works to remove this extraneous info... any ideas? Formula looks like: (((("#" & {Order Date}) & " - ") & Product) & " - ") & Supplier

I'm brand new to AirTable and appreciate any help. Thanks so much. https://airtable.com/appog8wBGoDN5Xiet/tblQuZFbeHjodwxpi/viwWiVK7K2wJqOX2E/fldnOc6mpaSiJv9t6

[Pascal_Gallais- · Accepted solution]

Hello Rachel,

You need to use DATETIME_FORMAT formula:

formula for field "Name" is:

I have chosen the date format to be "DD/MM/YYYY", you can define another format ("MM.DD.YYYY" for example)

Regards,

Pascal

[Rachel_Betzen]

Thank you so much!! 🙂 🙂 🙂