Help trying to re format dates


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 :slight_smile:

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!

2 Likes

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

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!

[
    {
        "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.

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