Help

DateAdd Formula + Set_Timezone

Topic Labels: Dates & Timezones
686 2
cancel
Showing results for 
Search instead for 
Did you mean: 
rhine-hwc
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all, 

I have a formula field that is used to output a date that is +28 days from a separate date field. Here is my current formula: 

 

 

DATEADD({470 Certification Sent Date}, 28,'days')​

 

 

I need this field to always be 12:00a in the 'Americas/New_York' time zone. 

Is it possible to create this output without accounting for the date/time/timezone the original entry is added in the "470 Certification Sent Date" field? If so, what do I need to append to the original formula?

Thanks for your help!

2 Replies 2
ferrettinico
4 - Data Explorer
4 - Data Explorer
It would be:
 
DATETIME_PARSE(DATETIME_FORMAT(SET_TIMEZONE(DATEADD({470 Certification Sent Date},28,'days'),'America/New_York'), 'M/D/Y h:mm A' ), 'M/D/Y h:mm A' )

Thanks for the input! 

This correctly sets the time zone while including the dateadd formula, but the time being displayed in this field is based on the time that the original source data was input into the 470 certification Sent Date field. 

My goal is to default the time in this field always be 12a in the 'America/New_York' time zone.