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