parseDate won't accept format token other than X if given unix time

[skanfklwef]

• use parseDate() to convert a unix time in milliseconds to 2024-07-01T19:00:00.000Z format
• I understand parseDate() uses seconds as input, so I already divided my input by 1000
  
  
• It works if I just do parseDate(1719860400 ; X)
• I don’t understand why I keep getting “The operation failed with an error. Failed to map ‘value’: Function ‘parseDate’ finished with error! ‘1719860400’ is not a valid date or does not match the date format.”

[samliew]

@skanfklwef

It works if I just do parseDate(1719860400 ; X)

yes this is correct.

then, you need to wrap it with formatDate with the format you want to transform the date into.

so something like this:

{{ formatDate(parseDate(1719860400; "X"); "YYYY-MM-DD") }}

For more information, see Parse and Format date tokens below:

Here are some useful links and guides to help you get started and learn more on how to use the Make platform, apps, and app modules —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate ← CHECK THIS OUT

Help Center Basics

• Mapping – What is mapping? What can I map? ← CHECK THIS OUT
• Mapping with arrays – How to map items in an array ← CHECK THIS OUT
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula
• How to use Regex in Make
• Getting started with OpenAI

samliew – request private consultation

Join the unofficial Make Discord server to chat with us!

[skanfklwef]

Thank you @samliew !!

{{formatDate(parseDate(1719860400000; "x"); "YYYY-MM-DDTHH:mm:ss.SSS"; "Zulu")}}Z

Produces the format I needed. The x token allows for milliseconds.