Skip to main content

Hi there!

I am trying to create a formula that will pull the Last Modified date and combine it with my initials and my Pending Items column. The formula I'm using right now works, but the Last Modified date is pulling tomorrow's date. I'm assuming this has something to do with time zones because it doesn't switch the date until 6pm CST, but I'm not sure how to fix it! Please help 😊

Table:

Formula:

CONCATENATE(DATETIME_FORMAT({Last Modified},'M/D/YY')," ","RE: ",{Pending Items})

 

Nest the SET_TIMEZONE() function inside DATETIME_FORMAT(). 

It is documented in the Formula Field Reference with the other date/time functions. 

Nest the SET_TIMEZONE() function inside DATETIME_FORMAT(). 

It is documented in the Formula Field Reference with the other date/time functions. 


This worked, thank you!!

 

CONCATENATE(DATETIME_FORMAT(SET_TIMEZONE({Last Modified}, 'America/Los_Angeles'), 'M/D/YY')," ","RE: ",{Pending Items})

Reply


Terms & Conditions