Return Carriage within a Formula for DATETIME_FORMAT SET_TIMEZONE

I need to add an additional carriage return within this formula where the red maple leaf is in the below formula. I’ve tried multiple different ways but I’m unable to find success. If anyone has any solutions would be most appreciative!!!

CONCATENATE(Patient, “\n”, DATETIME_FORMAT(SET_TIMEZONE({Start Date}, ‘America/New_York’), ‘LT - dddd :maple_leaf: MMM DD/YYYY’))

I’m not sure if it’s a bug or not that you can’t specify \n for a carriage return within a Date/Time format specifier, but I would just split your formula into multiple parts like this:

CONCATENATE(
Patient,
"\n",
DATETIME_FORMAT(SET_TIMEZONE({Start Date}, 'America/New_York'), 'LT - dddd'),
"\n",
DATETIME_FORMAT(SET_TIMEZONE({Start Date}, 'America/New_York'), 'MMM DD/YYYY')
)

Hope this helps! If this answers your question, could you please mark this comment as the solution to your question? This will help other people who have a similar question. :slight_smile:

1 Like

Thanks so much, truly grateful for you!!! :raised_hands: :slightly_smiling_face: :+1:

1 Like

You’re welcome! Glad I could help! :slight_smile:

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