Aug 21, 2024 07:29 AM
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
Solved! Go to Solution.
Aug 21, 2024 07:51 AM
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
Aug 21, 2024 07:51 AM
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
Aug 21, 2024 08:00 AM
Thank you so much!! 🙂 🙂 🙂