Welcome to the Make community!
You’re close, but first you have to PARSE date before you can FORMAT date.
This is because the JSON contains a string containing a formatted/readable date, but not an actual date object.
According to the Tokens you can use to parse a date variable, you can use YYYY-MM-DDTHH:mm:ss.SSSZ.
e.g.: {{ parseDate(1.date; "YYYY-MM-DDTHH:mm:ss.SSSZ") }}
Output
For more information, see Date Formats in the Help Center or the links below.
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
General
- Help Center | Tutorials
- Make Academy – learn Make and get your certificate
- Discord Server – join us in live chat for fans of Make!
Help Center Basics
- Mapping – What is mapping? What can I map?
- Mapping with arrays – How to map items in an array
- Aggregate an array for mapping complex fields
- Tokens for
parseDate| Tokens forformatDate - HTTP modules – Make a request, Get (download) a file
- Webhooks – Error Handling, Responding to webhooks
Articles & Videos
- Router Magic Formula - YouTube
- Error Handlers in Make - YouTube playlist
- Getting started with OpenAI
- How to use Regex in Make
samliew – request private consultation
Join the unofficial Make Discord server to chat with other makers!