I have an array with values and I have mapped all the dates (they are in timestamp format) and now I have all the dates in an array. So how do I change the format (DD/MM/YYYY) of all the dates in that array?

Welcome to the Make community! You should use the formatDate function before you aggregate the values into an array. According to the Tokens you can use to format a date variable, you can use DD/MM/YYYY. e.g.: {{ formatDate(now; "DD/MM/YYYY") }} For more information, see Date Format links below…

[image] [image] The problem is that I receive those dates in an array already and I need to modify the format of those dates

When you see ARRAY, think ITERATOR. [image] [image] Then, Aggregators Every result (item/record) from iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” …

Thanks @samliew for your support I really appreciate. But now I have a weird problem: I put the current time in timestamp format and when I use formatDate( to get the current date with this DD/MM/YYYY format, I get a date from 1970. Why am I not getting the current date? [image] [image]

@Clof_Company , You might have to parseDate() first and then formatDate(). use parseDate(date;x) to parse unix timestamp. See : [image] Convert text date to UNIX timestamp How To Hi Makers! I’m reaching out for help with one “easy” task - I need to convert this text strin…

Hi @Clof_Company You can use formatDate() function inside a text aggregator. First you will need to iterate the array. Regards Msquare Automation - Platinum partner of Make @Msquare_Automation

How to change the format of an array

Questions

kudracha January 29, 2025, 10:05am 6

@Clof_Company, You might have to parseDate() first and then formatDate(). use parseDate(date;x) to parse unix timestamp. See :

Topic		Replies	Views
How to format array into dates or Just time? Questions arrays	2	60	December 13, 2025
FormatDate in a Join Questions functions , mapping , arrays , error , ai	7	36	May 25, 2026
Double issues : one with \" in JSON array and another with Date formatting Questions arrays , json , format-date	4	264	June 7, 2024
How to use map() and match a timeline.from column data by formatDate() to YYYY-MM Questions monday	4	907	September 26, 2023
Applicate a "dateformat" function in a "map" function Questions arrays	3	278	May 16, 2024

How to change the format of an array

Related topics