Help

Concatenate not pulling accurate last modified date

Topic Labels: Dates & Timezones Formulas
Solved
Jump to Solution
271 2
cancel
Showing results for 
Search instead for 
Did you mean: 
RosalindaE
4 - Data Explorer
4 - Data Explorer

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:

RosalindaE_1-1703638828030.png

Formula:

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

 

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

Nest the SET_TIMEZONE() function inside DATETIME_FORMAT(). 

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

See Solution in Thread

2 Replies 2
kuovonne
18 - Pluto
18 - Pluto

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