Hi
Context:
I'm already inside the Multi-Row formula tool, have check if row ends with "a" has the same date with row that ends with "c" regardless of date formatting.
Input data(and expected outcome):
| Type | Input | Expected output |
| 1a | 2022-12-28,2023-03-28 | |
| 1b | | FALSE |
| 1c | 28-12-2022 | |
| 2a | 2023-01-04.2023-01-04 | |
| 2b | | TRUE |
| 2c | 4/01/2023, 04-01-2023 | |
| 3a | 2017-12-27,2018-03-26,2018-06-25,2018-09-25,2018-12-27 | |
| 3b | | FALSE |
| 3c | 2022-03-25,2022-06-27,2022-09-26,2022-12-28 | |
| 4a | 04-01-2023 | |
| 4b | | TRUE |
| 4c | 4/1/2023 | |
Attempted code (which doesn't work):
if EndsWith([Type],"b")
AND
Join(
Map(
RegEx_Replace([Row-1:Input], '[ ,]+', '|'),
DateTimeFormat(
DateTimeParse(Replace([Row-1:Input], '|', ','), 'M/d/yyyy|M/d/yy|yyyy-MM-dd|yy-MM-dd|MM/dd/yyyy|MM/dd/yy'),
'yyyy-MM-dd'
)
),
','
)
=
Join(
Map(
RegEx_Replace([Row+1:Input], '[ ,]+', '|'),
DateTimeFormat(
DateTimeParse(Replace([Row+1:Input], '|', ','), 'M/d/yyyy|M/d/yy|yyyy-MM-dd|yy-MM-dd|MM/dd/yyyy|MM/dd/yy'),
'yyyy-MM-dd'
)
),
','
)
then "TRUE"
else "FALSE"
endif
What I think the problem is:
Can't find Join and Map function... not sure what else can be used.
