I’m Trying to get the output of array aggregator of dates into just time , like from this : September 14, 2025 2:00 PM into this : 2:00 PM.
I’m getting a result of array is not a date.
Tried to use formatDate(Array) or formatDate(parseDate(Array)) .
Tried {{map(42.array; formatDate(42.array.start; " h:mm A"))}} = empty results
Tried doing DateOnly={{parseDate(1.message.text; “MM/DD/YYYY”)}} then {{remove(42.array; 14.DateOnly)}}
Hmmm, here is a potential solution:
Before your array aggregator, put a set variable module that converts the text into the time with this formula:
{{formatDate(parseDate(10.start; "MMMM DD, YYYY hh:mm a"); "hh:mm a")}}
where “10.start” is the data from the bundle that hte aggregator is looping on (the iterator, most likely).
The result is this:
The output of the JSON parser to simulate the input that you showed in your question.
The result of Set Variable:
The result of the Array Aggregator:
The big drawback is that it can consume a lot of operations if you have many entries.
L
