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:
2023-06-02T09:00:00.000Z
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
