Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to concatenate formula with date without messy time string

Topic Labels: Formulas
1126 1
cancel
Showing results for 
Search instead for 
Did you mean: 
shelby_jackson
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Reply 1

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.