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?
+21You’re looking for DATETIME_FORMAT()
Cheers,
Rupert
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.
+22Hey @Michael1!
Here’s a version of the formula that uses the CONCATENATE() function:
CONCATENATE(
{Task1}, " - ",
DATETIME_FORMAT(
{date}, 'l'
)
)
Here’s a version that forgoes the function:
{Task1} & " - " &
DATETIME_FORMAT(
{date}, 'l'
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.