Help

Convert multiple dates in one cell into multiple months in another

Topic Labels: Dates & Timezones
Solved
Jump to Solution
659 2
cancel
Showing results for 
Search instead for 
Did you mean: 
artichokejoe
4 - Data Explorer
4 - Data Explorer

If I have one date in a single cell, then I would use the formula 

DATETIME_FORMAT({}, 'MMMM) to convert that date into a month. 
 
However, sometimes when using a Look Up I'm pulling multiple dates, separated by commas, into one cell. I'd like to find a formula that will convert all of these multiple dates into the month equivalent. So solving the 'error below'.
 
 artichokejoe_0-1695974987229.png

Any help much appreciated. Thanks. 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

It's simple.
Add the "DATETIME_FORMAT({}, 'MMMM)" formula field to the Lookup source table.
Then, Lookup it.
If you make it a Rollup field instead of a Lookup field and use ARRAYUNIQUE(), only unique values will be displayed.

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

It's simple.
Add the "DATETIME_FORMAT({}, 'MMMM)" formula field to the Lookup source table.
Then, Lookup it.
If you make it a Rollup field instead of a Lookup field and use ARRAYUNIQUE(), only unique values will be displayed.

artichokejoe
4 - Data Explorer
4 - Data Explorer

Fantastic. That's worked. Thank you.