How to concatenate formula with date without messy time string

Hey AT community,

I can’t figure out why this formula isn’t working – AT is telling me it’s an invalid formula:

CONCATENATE({Full Name copy}, IF(NOT({Full Name copy}), Org), " - $", {Received Amount}, " - ",DATETIME_FORMAT({Date Received}, “D/M/YYYY”))

I want the formula to be [name or org] - {$received amount} - date received
Ex. John Smith - $5,000 - 09/02/2022

Thank you!

Aside from recommending you simplify your IF statement, I believe your issue is with the curly quotes around your date format.

CONCATENATE(
IF({Full Name copy}, {Full Name copy}, Org), 
" - $", {Received Amount}, 
" - ", IF({Date Received}, DATETIME_FORMAT({Date Received}, "D/M/YYYY"))
)

The IF around the date format will avoid errors for when no date is inputted.

1 Like

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.