
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 02, 2023 03:57 PM
Hey All!
I'm sure I'm overlooking a tiny detail, but here goes.
My existing formula is:
DATETIME_FORMAT({Date and Time},'MM-DD-YY h:mm a')&" GMT"&" - "&{Course Name}
The documentation shows to add a timezone, to do this:
DATETIME_FORMAT(SET_TIMEZONE("07/10/19 13:00", 'Australia/Sydney'), 'M/D/YYYY h:mm')
My take, that doesn't work, is this:
DATETIME_FORMAT(SET_TIMEZONE({Date and Time},‘America/New_York’),'MM-DD-YY h:mm a')& “ EST”& {Course Name}
Can anyone tell me what I'm doing wrong?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 02, 2023 11:17 PM
Can you include a screenshot of the error you are seeing?
My first guess is that your last formula includes a mix of curly quotes and straight quotes. Try replacing all the curly quotes with straight quotes.
I also like to use a multi-line format.
CONCATENATE(
DATETIME_FORMAT(
SET_TIMEZONE({Date and Time},'America/New_York'),
'MM-DD-YY h:mm a'
),
" EST ",
{Course Name}
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May 04, 2023 10:13 AM
Strangely the quotes are the same. however, when I repasted it in, it worked? Very strange.
