Date is being formatted for some reason?

Hi All,

Probably something really simple, but for some reason my dates are being formatted. The input date and out put formats are exactly the same, so not sure of the reason.
(date is in field 4, all inputs are dummy data)

Its literally a one step atomisation, so no where it should be going wrong.
Any ideas what could be the problem/how to stop this?

@Jennah_F
Hi, I don’t know the cause, but would using the formatDate function solve the problem?

Reference:
https://www.make.com/en/help/functions/tokens-for-date-time-formatting

Welcome to the Make community!

It’s possible that the DOB field has been defined as a date field, so Make will attempt to convert the string into a date type.

For more information, see the Type coercion page in the Make Help Centre, which covers the following:

  • When array is expected:
  • When Boolean is expected:
  • When Buffer is expected:
  • When Collection is expected:
  • When Date is expected:
  • When Number is expected:
  • When Text is expected:
  • When Time is expected:

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

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

For some reason, that comes out with no result. This is what I’ve done:

And its not being listed as an output at all. Input format remains the same

This is why I’m confused, according to that, shouldn’t it keep the same format? :sob:
Unless it’s adding time because its not included in the entries… but either case, I need the time to not be included :smiling_face_with_tear:

In that case try using the parseDate function first:

e.g.: (paste this into the field)

{{ formatDate(parseDate(1.date; "YYYY-MM-DD 00:00:00"); "YYYY-MM-DD") }}

or, you can simply split by a space character (assuming it’s possibly a string)?

e.g.: (paste this into the field)

{{ first(split(1.date; space)) }}

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

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

If you need further assistance, please provide the following:

Please provide the output bundles of module [4] by running the scenario (you can also get this without re-running your scenario from the History tab).

Click on the white speech bubbles on the top-right of each module and select “Download input/output bundles”.

A. Upload as a Text File

Save each bundle contents in a plain text editor (without formatting) as a bundle.txt file.

You can upload the file here by clicking on this button:

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, especially if there are complex data structures (nested arrays and collections) or if external services are involved.

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.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Thanks for your help so far Sam!

Unfortunately, I couldnt get the above to work either. I copied and pasted, and got an error as 1.Date wasn’t found anywhere. I replaced that with the raw data, and, as before, nothing happened. This was for both solutions. I tried replacing “Space” with “TimeStamp”, but also no results.

This is from the ParseDate trial:
Input:

[
    {
        "fields": {
            "DOB": "2025-03-07T00:00:00.000Z",
            "Country": "Brazil",
            "SunSign": "Unknown",
            "LastName": "uhjn",
            "MoonSign": "Unknown",
            "FirstName": "uhj",
            "RisingSign": "Unknown",
            "ReferredFrom": "Search Engine (Google, Bing, etc.)"
        },
        "listId": "f3c19de6-d12b-11ef-80b1-2731619ca0c3",
        "status": "SUBSCRIBED",
        "email_address": "yiun@yuj.co"
    }
]

Output:

[
    {
        "id": "c954f466-04ef-11f0-9923-15af9dd07d0d",
        "email_address": "yiun@yuj.co",
        "fields": {
            "FirstName": "uhj",
            "LastName": "uhjn",
            "SunSign": "Unknown",
            "MoonSign": "Unknown",
            "RisingSign": "Unknown",
            "ReferredFrom": "Search Engine (Google, Bing, etc.)",
            "Country": "Brazil"
        },
        "status": "SUBSCRIBED",
        "created_at": "2025-03-19T18:27:17.000Z"
    }
]

Split Trial:
Input

[
    {
        "fields": {
            "DOB": "2025-03-08T00:00:00.000Z",
            "Country": "Argentina",
            "SunSign": "Aquarius",
            "LastName": "uyhn",
            "MoonSign": "Unknown",
            "FirstName": "ygu",
            "RisingSign": "Unknown",
            "ReferredFrom": "Social Media"
        },
        "listId": "f3c19de6-d12b-11ef-80b1-2731619ca0c3",
        "status": "SUBSCRIBED",
        "email_address": "uyh@uhnj.co"
    }
]

Output:

[
    {
        "id": "8b9e7d1c-04f0-11f0-a66c-9f71043b2a56",
        "email_address": "uyh@uhnj.co",
        "fields": {
            "FirstName": "ygu",
            "LastName": "uyhn",
            "SunSign": "Aquarius",
            "MoonSign": "Unknown",
            "RisingSign": "Unknown",
            "ReferredFrom": "Social Media",
            "Country": "Argentina"
        },
        "status": "SUBSCRIBED",
        "created_at": "2025-03-19T18:32:42.000Z"
    }
]

Im sure its something super simple that I’m missing!

Perhaps you should simply try to “Redetermine the Data Structure” of the webhook. This is because the DOB field is not being recognised, and “Field 4” may be an outdated variable.

For more information, see the Webhooks page in the Make Help Centre, which covers the following:

  • Creating app-specific webhooks
  • Creating custom webhooks
  • Scheduling webhooks processing
  • How Make processes webhooks
  • Webhook settings
  • Error Handling
  • Supported incoming data formats
  • Webhook headers
  • Responding to webhooks
  • HTML Response example
  • Redirect example
  • Custom mailhook
  • Webhook rate limit
  • Troubleshooting Webhooks

and also,

  • Inserting webhooks to scenarios
  • Setting up webhook data structure
  • Parallel vs. sequential processing
  • Processing scheduled webhooks
  • Webhook queue details
  • Query String
  • Form Data
  • Multipart
  • JSON
  • Mailhook attachment size limit
  • Missing items in the mapping panel

Then, send a new request to your webhook, and provide the updated output bundle of your trigger module [3].

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

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.