make.comintegromat-apps

How to parse this date: 2017-11-28T23:00:00Z in custom Integromat app?

Does someone have complete solution how to parse this date: 2017-11-28T23:00:00Z?

Solution

  • Currently, the only format that does not need to be parsed manually is the one that includes milliseconds: 2017-11-28T23:00:00.000Z.

    In your specific case, use parseDate(your-date-field; YYYY-MM-DDTHH:mm:ssZ).
    The date/time parsing tokens are explained here.