Skip to main content
Solved

Concatenate not pulling accurate last modified date

  • December 27, 2023
  • 2 replies
  • 43 views
R
Forum|alt.badge.img+3

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

 

Best answer by kuovonne

Nest the SET_TIMEZONE() function inside DATETIME_FORMAT(). 

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

2 replies

kuovonne
Forum|alt.badge.img+29
  • kuovonne
  • Brainy
  • Answer
  • December 27, 2023

Nest the SET_TIMEZONE() function inside DATETIME_FORMAT(). 

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

R
R
Forum|alt.badge.img+3
  • RosalindaE
  • Author
  • New Participant
  • December 28, 2023

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})
Terms & ConditionsAccessibility statement