Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

can't delete timezone

Topic Labels: Dates & Timezones
Solved
Jump to Solution
656 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Rachel_Betzen
4 - Data Explorer
4 - Data Explorer

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

1 Solution

Accepted Solutions
Pascal_Gallais-
9 - Sun
9 - Sun

Hello Rachel,

You need to use DATETIME_FORMAT formula:

Pascal_Gallais_0-1724251672292.png

formula for field "Name" is:

Pascal_Gallais_1-1724251743177.png

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

Regards,

Pascal

See Solution in Thread

2 Replies 2
Pascal_Gallais-
9 - Sun
9 - Sun

Hello Rachel,

You need to use DATETIME_FORMAT formula:

Pascal_Gallais_0-1724251672292.png

formula for field "Name" is:

Pascal_Gallais_1-1724251743177.png

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

Regards,

Pascal

Thank you so much!! 🙂 🙂 🙂