Format Date always Returns 1/20/1970

[clarezoe]

I’m getting a Unix formated timestamp, and I’m using parseData to convert to regular date format

{{parseDate(1712299628; "x")}}

But no matter what number I try, it always returns 1/20/1970, sometimes 1/21/1970

I don’t know what went wrong. Please help!
Thanks in advance!

[Emmie_Aderemi]

Hey @clarezoe what you need is ‘‘formatdate’’ formula

[samliew]

Welcome to the Make community!

According to the Tokens you can use to format a date variable, you can use X (capitalised).

e.g.:

{{ formatDate(now; "X") }}

Proof:

For more information, see Date Format links below @Emmie_Aderemi

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 —

Getting Started

• Help Centre | Tutorials – Make “Manual”
• Make Academy – Basics 101: Learn Make and get certified

Help Centre 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
• Date Format: 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 - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
• How to use Regex in Make - How to use pattern matching to extract the text you want
• Webhooks – Make Academy – tutorial on how to use Webhooks

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.

[clarezoe]

Thank you! Change the x to capitalised solved it.