Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Modifying date part using concatanate formula

Topic Labels: Dates & Timezones
285 2
Showing results for 
Search instead for 
Did you mean: 

When I’m using concatenate formula for a unique ID, I’m using it like this CONCATENATE(Task1," - ",{date}). And it ends up being weird-looking, and when I say weird looking I mean only date part is weird. This is what I get “Task 1-2022-02-10T[00:00:00:000Z”. How can I remove those zeroes?

2 Replies 2

You’re looking for DATETIME_FORMAT()


PS: Instead of using Concatenate, you can also build a string from fields with “&” → {Field1}&" "&{Field2}, I find it easier to work with, especially with long concatenations.

Hey @Michael1!

Here’s a version of the formula that uses the CONCATENATE() function:

    {Task1}, " - ",
        {date}, 'l'

Here’s a version that forgoes the function:

{Task1} & " - " & 
    {date}, 'l'