Extracting the first Date&Time from an array: Formatting problem

Topic Labels: Formulas
141 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

Hello everyone,

I'm trying to extract the first Date&Time from an array from a lookup field that looks like this:

2023-06-02 11:00, 2023-06-07 11:30, 2023-06-12 11:45, 2023-06-23 11:00, (etc)

But using this formula:

ARRAYSLICE({Lookup field}, 1, 1)
Gives this result:
which doesn't get recognized as a Date&Time, so I can't format it.
Is there maybe something I'm doing wrong? Thanks in advance for any advice
0 Replies 0