Help

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

Topic Labels: Formulas
141 0
cancel
Showing results for 
Search instead for 
Did you mean: 
pedrotecla
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:
 
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
0 Replies 0