Skip to main content
Solved

can't delete timezone

R

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

Best answer by Pascal_Gallais-

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

View original
    Did this topic help you find an answer to your question?

    2 replies

    Pascal_Gallais-

    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

    R
    1 person likes this
    • R
      Rachel_Betzen
    R
    • Rachel_Betzen
    • Author
    • New Participant
    • 1 reply
    • August 21, 2024
    Pascal_Gallais- wrote:

    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


    Thank you so much!! 🙂 🙂 🙂

    Reply


    Most helpful members this week

    Terms & Conditions