Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

How to concatenate formula with date without messy time string

Topic Labels: Formulas
144 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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.