# How to format array into dates or Just time?

**URL:** <https://community.make.com/t/how-to-format-array-into-dates-or-just-time/91882>\
**Category:** Questions\
**Tags:** arrays\
**Created:** [September 13, 2025, 7:05pm UTC](https://community.make.com/t/how-to-format-array-into-dates-or-just-time/91882 "2025-09-13T19:05:03Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![office\_design](https://avatars.discourse-cdn.com/v4/letter/o/90ced4/32.png) [@office\_design](https://community.make.com/u/office_design)\
**Post date:** [September 13, 2025, 7:05pm UTC](https://community.make.com/t/how-to-format-array-into-dates-or-just-time/91882/1 "2025-09-13T19:05:03Z")

</div>

### What are you trying to achieve?

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.

### Steps taken so far

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)}}

### Screenshots: scenario setup, module configuration, errors

 ![Screenshot 2025-09-14 030352.png](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/c/1/c15c3ec11f7589dbc166b4d52053694a4d67b3a7.png)  
 ![Screenshot 2025-09-14 030426.png](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/2/a/2a74aa7e51c76f292297b8e36bd2fe9ce2f155db.png)

---

<div class="post-metadata">

**Author:** ![L\_Duperval](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/l_duperval/32/44239_2.png) [@L\_Duperval](https://community.make.com/u/L_Duperval)\
**Post date:** [September 14, 2025, 2:48am UTC](https://community.make.com/t/how-to-format-array-into-dates-or-just-time/91882/3 "2025-09-14T02:48:17Z")

</div>

Hmmm, here is a potential solution:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/9/8/98377068966311323f569c1fe38f641edf99aa57.png)

Before your array aggregator, put a set variable module that converts the text into the time with this formula:

```auto
{{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:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/e/7/e789520fc1b92cef10a977f719fadf6c424f90f5.png)

The output of the JSON parser to simulate the input that you showed in your question.

The result of Set Variable:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/1/c/1c1d8a5740cc16416fdc8d90c5f6e50e1f4ca10b.png)

The result of the Array Aggregator:

 ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/4/8/48474e230621cf72c4f4747904c9d196abc63f7a.png)

The big drawback is that it can consume a lot of operations if you have many entries.

L

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [December 13, 2025, 3:57am UTC](https://community.make.com/t/how-to-format-array-into-dates-or-just-time/91882/4 "2025-12-13T03:57:03Z")

</div>

This topic was automatically closed because it's resolved or inactive. Please, start a new topic.