Help

Formula - adding time zone, not working??

Topic Labels: Dates & Timezones
623 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sean_Lake1
8 - Airtable Astronomer
8 - Airtable Astronomer

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?

 

2 Replies 2

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}
)

 

Sean_Lake1
8 - Airtable Astronomer
8 - Airtable Astronomer

Strangely the quotes are the same. however, when I repasted it in, it worked?  Very strange.