Skip to main content

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!

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

Reply


Terms & Conditions