Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Merge dates for linked records

Topic Labels: Formulas
149 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sandrine_Coosem
6 - Interface Innovator
6 - Interface Innovator

I'm managing 5 websites, and have created one base with 5 tables - each reflecting the blog planning for one website (syncing with the website-specific bases). I've now created a table that collects all the posts from all the websites, so I can see where everything is at in a blink of an eye. 

What I can't wrap my head around is the dates: I now have 5 date fields (lookups), but I'd like to be able to sort things by date (or display them in a calendar, etc) - regardless of which website it's for. I created a formula field to merge the dates, but that displays them as "2015-01-01T00:00:00.000Z"... I know there's a DATESTR([date]) formula, but that gets me an error message (am I using it wrong?). 

Any help would be greatly appreciated! 

2 Replies 2

Does this look right?
Screenshot 2025-02-07 at 5.42.14 PM.png

DATETIME_PARSE(
  {Date (from Site 1)} & {Date (from Site 2)}
)

And I've set it up for you here

Sandrine_Coosem
6 - Interface Innovator
6 - Interface Innovator

Absolutely perfect, worked like a charm! Thank you so much, Adam.