formatDate Timezone struggles

I’m struggling to achieve something rather simple, and can’t figure out what I’m doing wrong.

I’m receiving a date value from scheduling app, ScheduleOnce, e.g. “2022-08-08T17:30:00Z”

And attempting to use this formula in the body text of a Mail module, but it still outputs the GMT time, no matter what timezone I specify:

Thanks for any help!

Hi @Frank_Gannon, this is odd. Your formulas look ok to me, I just did a test and I got it to behave as expected.


Could you show us the following:

  • raw input and output of your email module
  • output of your Schedule Once webhook

wiseflow.co
Our Blog
Need Make expert support quickly? Book a session

Thanks for looking into it! I believe this is all the info you requested:

Email input:


Email output:
email_output

ScheduleOnce output:

Cheers!

I think you might have an extra space in front of America/Los_angeles and America/New_york :sweat_smile: if the timezone description is not exact Make ignores it. If this is not it, then I don’t know :exploding_head:

1 Like

That was it :man_facepalming:
I swore I went through and checked for spaces already, too! :rofl:

Thanks so much for your time!

1 Like

:+1: excellent !

When you drag and drop the variable it often creates a heading space :pensive:

1 Like