Help trying to re format dates

Daniel_Raphael · August 13, 2024, 12:23pm

so basically I have this array of data.
My goal is to filter the modifiedon: (date) to only give me the collections whose date is today. But as seen the format is with YYYY-MM-DD HH-SS
which means I need to change the format in some way that doesn’t cost me too much operations.

Thanks to all the helpers

samliew · August 13, 2024, 1:16pm

Welcome to the Make community!

You can use the built-in functions parseDate and formatDate

e.g.:

{{ formatDate(parseDate(1.modifiedon; "original-date-format"); "target-date-format") }}

For more information, see the function documentation in the Help Center.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

Daniel_Raphael · August 14, 2024, 9:34am

Hi Sam thanks for the reply,
I realised it had something to do with these functions, but even with the right function I still can’t figure out how to use it as a filter

samliew · August 14, 2024, 9:41am

No problem, could you provide the full output bundle so I can create an example for you?

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

Method 1: Type code block manually

Add three backticks ``` before and after the content/bundle, like this:

```
^{content goes here}
```
Method 2. Highlight and click the format button in the editor

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

This will allow others to better assist you. Thanks!

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!

Daniel_Raphael · August 14, 2024, 11:23am

[
    {
        "modifiedon": "2024-08-14T12:29:53",
        "statuscode": "פולואפ - הועבר לשיחה עם יועצת",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 1,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:25:39",
        "statuscode": "פולואפ - הועבר לשיחה עם יועצת",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 2,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:23:39",
        "statuscode": "הופסד ❌",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 3,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:21:42",
        "statuscode": "הופסד ❌",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 4,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:20:19",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 5,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:18:47",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 6,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:11:53",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 7,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:08:58",
        "statuscode": "אין מענה 1",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 8,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:07:09",
        "statuscode": "אין מענה 1",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 9,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:05:15",
        "statuscode": "פולואפ - הועבר לשיחה עם יועצת",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 10,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:03:56",
        "statuscode": "פולואפ - הועבר לשיחה עם יועצת",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 11,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T12:00:25",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 12,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T11:58:44",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 13,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T11:53:52",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 14,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T11:52:13",
        "statuscode": "אין מענה 1",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 15,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T11:36:05",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 16,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T11:29:18",
        "statuscode": "הופסד ❌",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 17,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T11:03:09",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 18,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:53:58",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 19,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:52:02",
        "statuscode": "רענון ליד בתהליך (לשימוש השיווק בלבד)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 20,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:48:29",
        "statuscode": "פולואפ - הועבר לשיחה עם יועצת",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 21,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:48:13",
        "statuscode": "רענון ליד בתהליך (לשימוש השיווק בלבד)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 22,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:47:27",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 23,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:46:15",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 24,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:44:55",
        "statuscode": "רענון ליד בתהליך (לשימוש השיווק בלבד)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 25,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:34:15",
        "statuscode": "רענון ליד בתהליך (לשימוש השיווק בלבד)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 26,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:33:18",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 27,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:30:08",
        "statuscode": "הופסד ❌",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 28,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:30:06",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 29,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:29:41",
        "statuscode": "רענון ליד בתהליך (לשימוש השיווק בלבד)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 30,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:29:36",
        "statuscode": "פולואפ - הועבר לשיחה עם יועצת",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 31,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:28:46",
        "statuscode": "הופסד ❌",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 32,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:28:28",
        "statuscode": "הופסד ❌",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 33,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:28:23",
        "statuscode": "רענון ליד בתהליך (לשימוש השיווק בלבד)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 34,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:27:58",
        "statuscode": "רענון ליד בתהליך (לשימוש השיווק בלבד)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 35,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:27:58",
        "statuscode": "הופסד ❌",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 36,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:27:12",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 37,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:27:05",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 38,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:09:11",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 39,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:08:10",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 40,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:07:07",
        "statuscode": "אין מענה 2",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 41,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:02:36",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 42,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T10:00:46",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 43,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:59:39",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 44,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:58:05",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 45,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:56:20",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 46,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:54:00",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 47,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:49:10",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 48,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:48:22",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 49,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:46:51",
        "statuscode": "אין מענה 2",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 50,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:46:24",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 51,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:43:29",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 52,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:42:52",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 53,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:41:00",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 54,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:40:01",
        "statuscode": "ליד כפול",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 55,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:39:46",
        "statuscode": "ליד כפול",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 56,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:39:28",
        "statuscode": "ליד כפול",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 57,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:38:32",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 58,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:37:20",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 59,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:36:39",
        "statuscode": "אין מענה 3",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 60,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:35:58",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 61,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:33:26",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 62,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:31:22",
        "statuscode": "הופסד ❌",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 63,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:21:24",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 64,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:20:21",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 65,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:17:57",
        "statuscode": "אין מענה 1",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 66,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-14T09:15:34",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 67,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-13T14:09:27",
        "statuscode": "הופסד ❌",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 68,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-13T14:05:03",
        "statuscode": "הופסד ❌",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 69,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-13T14:04:19",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 70,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-13T14:03:29",
        "statuscode": "אין מענה 2",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 71,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-13T14:01:46",
        "statuscode": "פולואפ - לחזור במועד אחר",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 72,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-13T13:54:11",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 73,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-13T13:50:23",
        "statuscode": "נקבעה פגישת ייעוץ⏱️ (תואם)",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 74,
        "__IMTLENGTH__": 500
    },
    {
        "modifiedon": "2024-08-13T13:45:19",
        "statuscode": "ליד כפול",
        "pcfsystemfield15": "אשדוד",
        "__IMTINDEX__": 75,
        "__IMTLENGTH__": 500
    },
    {

]

ok so I got the function to work, now my question is :
I want to somehow count all these bundles by the “pcfsystemfield15” field inside, and have it returned as value “pcfsystemfield15” : “ex1” = 5
“ex2” = 10.

samliew · August 14, 2024, 12:24pm

What is ex1 and ex2? You should create a new question if it is not related to dates.

Topic		Replies	Views
How to format an entire array of date objects? How To mapping , arrays	1	25	October 25, 2024
Formatting dates from different apps in a scenario How To functions , mapping	4	34	September 5, 2024
Sorting Arrays by Date/Time How To arrays	1	53	September 27, 2024
Created an Automation that should move set date to Thursday if it's on Fri-Sat, doesn't work.. any guesses why? How To functions , mapping	6	19	August 20, 2024
Format-Date flips month and day when the day value is lower than 12 How To format-date	2	14	November 1, 2024

Help trying to re format dates

A. Upload as Text File

B. Insert as Formatted Code Block

Related topics