DateAdd + Last Modified Time

[Dreidel_Lopez]

Hey Community,

I’m trying to create a formula to add 7 days to a {Date} and add the Last Modified time to the the end of the result. I am currently using this formula

DATEADD({Date}, 7,‘day’) & DATETIME_FORMAT({Last Modified}, ‘h:mm’)

but this is what I get back
example:

2021-12-07T00:00:00.000Z6:35

I have also tried adding

SET_TIMEZONE({Last Modified}, ‘America/Los_Angeles’

after the DateTime_Format but I am met with the same result. Would love some help please!

[Justin_Barrett]

You’ll need to format both dates, not just the second one, and add a separating space between them.

DATETIME_FORMAT(DATEADD({Date}, 7, "day"), "L") & " " & DATETIME_FORMAT({Last Modified}, "h:mm")