Why is the date not adding hours

How To
1

Hey, I have this date as input for a scenario

November 30th, 9:40am

I am using this formula to get and format the date

{{addHours(formatDate(parseDate(`November 30th, 9:40am`; "MMM Do, HH:mm a"); "M/D/YYYY h:mma"); 3)}}

and I also add 3hrs cause the input date has California timezone and I want the output to have New York timezone so I don’t know how to tell MAKE that this is the time zone of input data and I want the output to have the NY time zone.

Anyways what I thought of doing was add 3 hrs to the input date as that is the time zone difference but it isn’t working for me.

Could anyone tell me what am doing wrong here

2

Hi @Fahad_Sheji

When you use format date, it’s no longer a date object, so get rid of the format date inside, and take it out to the last that means:

{formatdate;{addHours(parseDate(November 30th, 9:40am; “MMM Do, HH:mm a”); 3)}MMM Do, HH:mm a}

Make adjustments to the formula…

2 Likes
3

Hey, was thinking of asking this question related to this as a post to this community but thought I’d ask you first

Is there a way I can tell MAKE when formatting a date that this is the time zone of input data and I want the output to have another time zone.

Something like this

image
image1095×594 84.5 KB

4

Input DateTime object is always in UTC, but output can be any other timezone, your method is right, read formatdate documentation for proper timezone settings.

1 Like
5

How can I change the input object’s time zone, is it possible on Make?

I know how to change the time zone of the output data but haven’t figured out how to change the time zone of the input data from UTC to any variable time zone I set