Concatenate not pulling accurate last modified date

[RosalindaE]

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

[kuovonne · Accepted solution]

Nest the SET_TIMEZONE() function inside DATETIME_FORMAT(). 

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

[RosalindaE]

This worked, thank you!!

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