Format Date always Returning 1/20/1970

[Jeffrey_Hart]

I’m trying to pass data into a Google Sheet that contains a unix formatted timestamp like this: 1705121580

I’m using the formatDate function to try to convert this to MM/DD/YYYY format (and to get the month/day/year values independently, as well). However, it always seems to output 1/20/1970.

You can see how I’ve set this up below. I tried using parseDate within formatDate, but that ended up erroring out and giving me odd dates.

[samliew]

Welcome to the Make community!

According to the Tokens you can use to parse a date variable, you can use x (lowercase X)

e.g.: parseDate(1705121580;x)

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
• Make Blog – get the latest updates
• Features & Pricing

Help Center Basics

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