Solving formatDate Issue in Monday Automation

Hi Makers,

I am currently working on Monday automation and I have a part where I aggregated the data and I wish to do a filter before going to next module. Ideally, my filter should use map() to loop through the array and format the date to YYYY-MM from YYYY-MM-DD format so I can just compare based on the year and month. However, the formatDate() does not seem working with map(), would like to know how can I make this happen?

Here is my scenario and specific filter:

map() will result a array value, at the same time formateDate will not accept they array. To solve issue, please use get() after map() to get the value from array.

Thanks for your reply, however this get() always getting the first object in the array only. Hence, I did a workaround to make my scenario happens. I aggregate to JSON with the object data that I will be using after this module, and filter if the specific match in the JSON string. If yes, parse the JSON and continue with the filter to populate with the specific data set.

Just wanted to jump in and congratulate you on solving this one. I’m glad to see that you got the ball rolling. Thank you very much for getting back to us and sharing your solution with us. We honestly appreciate that you kept us in mind and marked the problem as solved so other users can easily find it while having similar issues.

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.